Formula to compare dates

[LGuest]

I am trying to figure out why I cannot get this formula to
work on Excel 2000. It seems to only select the "true"
option if I put in a date less than 06/30/03. For
comparing dates in Excel, do you put them in quotes or not?

=IF(D1>="6/30/03","active","approved")

 

[Chip Pearson]

Use the DATE function to ensure that you get a proper Excel date
value. E.g.,

=IF(D1>=DATE(2003,6,30),"active","approved")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)