Greater than/Less than between 2 Dates [Solved/Closed]

Posts
4
Registration date
Monday May 13, 2013
Last seen
May 13, 2013
- - Latest reply: TrowaD
Posts
2441
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 18, 2018
- May 13, 2013 at 11:36 AM
i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or greater than 01/01/2013 then populate the cell with $38.46. What am I doing wrong? When I change the <> signs around one of the formulas works.

Here is the formula: =IF(B18<=1/1/2013,"$38.46","$500.00")
See more 

2 replies

Posts
2441
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 18, 2018
400
0
Thank you
Hi Shaynajr,

That is because you didn't told Excel it is a date.

Try this:
=IF(B18>=DATE(2013,1,1),"$38.46","$500.00")

Best regards,
Trowa
Posts
4
Registration date
Monday May 13, 2013
Last seen
May 13, 2013
0
Thank you
Thank you so much - it worked. You rock.
TrowaD
Posts
2441
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 18, 2018
400 -
Thanks for the feedback.

See you around.