Help with date formula

[Guest]

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.

 

[Guest]

Maybe:-

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

Mike

 

[Dave Peterson]

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

 

[Guest]

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

Life savers...

ang.