Is this even possible?

  • Thread starter Thread starter KeyAdministration
  • Start date Start date
K

KeyAdministration

Bear with me as I try to explain.

On my cash flow sheet, I have a list of store locations that will open
through different times in the next three years.
What I'm trying to do is have the document recognize when a store opens to
automatically generate one-time expenses. (I've already plugged in all the
function and formulas for monthly expenses through a 'Values' sheet within my
workbook)

Each store location has a potential opening date. I don't want to manually
input the one-time charges in case those dates change for one reason or
another.

Is there a function that would recognize the date and input the correct
amount in the right column?

Thanks,

--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support
 
=IF(opening_date<=TODAY(),publicity_costs_value,"")

etc., as an example.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thank you, this gives me something to work with however it isn't going to
work for multiple locations! *sigh*
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support
 
What do you mean by multiple locations?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
After deciphering your signature, I sent an email.
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support
 
Back
Top