dariuzthepole
Board Regular
- Joined
- Jul 23, 2008
- Messages
- 111
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.
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.