=IF(DAY(A1)=12;TRUE;FALSE)

HTH
--
AP

"nandin11" a écrit
dans le message de news:
...

Hi,

I have dates formatted as 12-Jan-1967 (in A1) and 11-Jan-1967(in B1).
How do I tell Excel to take the date 12-Jan-1967 in C1 since I want
only the dates from/after the 12th day of the month? Since the dates
are stored as numbers is there a way to check for the first two digits
and if the first two digits are less than 12 then to reject that date?
Basically all I want to do is extract dates from the 12th and reject
the ones before the 12th of any month. Thank you!


--
nandin11
------------------------------------------------------------------------
nandin11's Profile:
http://www.excelforum.com/member.php...o&userid=34840
View this thread: http://www.excelforum.com/showthread...hreadid=545869