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.