Microsoft Excel 010 - complete package

Hi, I am trying to include a formula that says..... if the date in A1 is less than 1/31/2012 then put a 1 if not, put a zero but when I try to do that it isn't recognizing 1/31/2012 as a date. It converts it to a number. Any help would be appreciated!

You didn't post your formula so it's a little hard for us to point out your "error", if there is indeed one. The best we can do is suggest how

wemight construct the formula.=IF(A1<DATEVALUE("1/31/2012"), 1, 0)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

check to see what the formatting for the cell is a date format. There is a possibility that you are looking at Microsofts date value. also check your system variables in your operating system so see how your date is set up.

year/month/day

day/month/year

month/day/yearIn the US it tends to be Month/day/year

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History