Is this even possible?

[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

 

[Bob Phillips]

=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)

 

[KeyAdministration]

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

 

[Bob Phillips]

What do you mean by multiple locations?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[KeyAdministration]

After deciphering your signature, I sent an email.
--
Chantal Livingstone
Virtual Business Assistant

Key Administration
Comprehensive Business Support