Date within IF Function

[dariuzthepole]

Hi All,

I'm looking to reference a particular cell, depending on a date. I presumed the syntax would be along the lines of...

=IF(date<23/03/2009,A1,B1)

...but I can't figure it out. I've tried replacing DATE with TODAY also.

Basically this is for budgeting purposes. My girlfriend is pregnant (I'm gonna be a daddy!) and she will earn differing amounts (statutory maternity pay etc) depending on dates, so I'm looking to include this in a basic budget spreadsheet I already have.

Any help you could give me would be much appreciated.

 

[VoG]

Congratulations.

Does this work as expected?

=IF(TODAY()>DATEVALUE("23/3/09"),A1,B1)

 

[onlyadrafter]

Hello,

try

=IF(TODAY() < DATEVALUE("25/3/2009"),A1,B1)

 

[Willem!]

Hi,

Is 'date' a named cell? A simple IF-statement works just fine for me;

(e.g.)

=IF(NOW()>12/1/2009,A1,B4)

Can you clarify your problem?