Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
If Statements and DATES
0 views
Skip to first unread message
Dan McGowan
Aug 29, 2003, 9:52:58 AM8/29/03
to
I am trying to run a IF statement using dates and I'm
running into problems - I want to be able to populate
another cell with text based on the outcome of my IF
statement- example, if the date in a cell is less than or
equal to a defined date, then populate a cell with "GO" -
=IF(C5<=12/1/2003,"DELIVER", ""). Is there something
excel doesnt like about dates, or is there formatting that
needs to occur? I cant believe Excel cant perform IF
statements on dates......any help or ideas is greatly
appreciated.
running into problems - I want to be able to populate
another cell with text based on the outcome of my IF
statement- example, if the date in a cell is less than or
equal to a defined date, then populate a cell with "GO" -
=IF(C5<=12/1/2003,"DELIVER", ""). Is there something
excel doesnt like about dates, or is there formatting that
needs to occur? I cant believe Excel cant perform IF
statements on dates......any help or ideas is greatly
appreciated.
Thanks in advance
Viscount
Aug 29, 2003, 10:10:32 AM8/29/03
to
You will need to use the DATE function...
=IF(C5<=(DATE(2003,1,12)), "Deliver", " ")
If that does not work try DATEVALUE
=IF((C5<=DATEVALUE("2003/1/12")), "Deliver", " ")
Vis
>.
>
0 new messages