Extracting Dates

N

nandin11

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!
 
D

Daniel CHEN

=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
=================================
 
N

nandin11

Hi,

Something does not seem to be cutting it. Is there a special way that
the cells in A1 and B1 have to be formatted for this to work?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Dates 3
Problem with MS Word paragraph and character styles: format getting messed up 2
Number of dates falling in a date range 7
help counting 2
Group Dates by Week? 3
Allocate an income payment over a date range (tax years) 7
IF ARRAY with multiple conditions. 1
Keep First Letters, with exceptions 0

Top