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)

"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

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" wrote:

=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

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

=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

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

Key Administration
Comprehensive Business Support


"Bob Phillips" wrote:

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

=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