=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" wrote in
message ...
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