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

=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

=IF(DAY(A1)=12,A1,"")
Remember to format C1 as date
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"nandin11" wrote in
message ...

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