Help with date formula
 

Hi,

I have a sales forecast spreadsheet and want the sheet to automatically
report 'actual' values rather than forecasted ones when the end of the month
occurs.

i.e. i would like the formula to be something like this but just can't seem
to get to the right combination:

=if the current date (today's date) is less than or equal to <=30/09/07,
return value in C4, if not return value in C13.

It sounds simple but i am not sure how to display the date section for
checking what the current date is.


ANY help would be appreciated, i am going around in circles!

Thanks,

Ang.

Help with date formula
 

Maybe:-

=IF(NOW()DATE(2007,9,30),C4,C13)

Mike

"Ang" wrote:

Hi,

I have a sales forecast spreadsheet and want the sheet to automatically
report 'actual' values rather than forecasted ones when the end of the month
occurs.

i.e. i would like the formula to be something like this but just can't seem
to get to the right combination:

=if the current date (today's date) is less than or equal to <=30/09/07,
return value in C4, if not return value in C13.

It sounds simple but i am not sure how to display the date section for
checking what the current date is.


ANY help would be appreciated, i am going around in circles!

Thanks,

Ang.

Help with date formula
 

=today() will give today's date.
=now() will give the date and time.

Ang wrote:

Hi,

I have a sales forecast spreadsheet and want the sheet to automatically
report 'actual' values rather than forecasted ones when the end of the month
occurs.

i.e. i would like the formula to be something like this but just can't seem
to get to the right combination:

=if the current date (today's date) is less than or equal to <=30/09/07,
return value in C4, if not return value in C13.

It sounds simple but i am not sure how to display the date section for
checking what the current date is.

ANY help would be appreciated, i am going around in circles!

Thanks,

Ang.

--

Dave Peterson

Help with date formula
 

Working!, thanks so much......

Life savers...

ang.

"Dave Peterson" wrote:

=today() will give today's date.
=now() will give the date and time.

Ang wrote:

Hi,

I have a sales forecast spreadsheet and want the sheet to automatically
report 'actual' values rather than forecasted ones when the end of the month
occurs.

i.e. i would like the formula to be something like this but just can't seem
to get to the right combination:

=if the current date (today's date) is less than or equal to <=30/09/07,
return value in C4, if not return value in C13.

It sounds simple but i am not sure how to display the date section for
checking what the current date is.

ANY help would be appreciated, i am going around in circles!

Thanks,

Ang.

--

Dave Peterson