Extracting Dates

  • Thread starter Thread starter nandin11
  • Start date Start date
N

nandin11

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!
 
Hi,

Thank you for your reply. Something does not seem to be working and
am sure it's an oversight on my part. I have 11-Jan-67 in E2 an
14-Jan-67 in G2 and in H2 =IF(DAY(E2<12),G2,E2) and yet it stil
returns the value of 11-Jan-67. Is there some special formatting
should follow?

Thank you
 

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
How do you format a number into a date? 6
Formula to display next Friday from B1 works except on the Friday itself. 4
running total between two dates 3
Date Input Mask - inconsistent displayed value 1
Report data from cell if dates match 2
Report data from cell if dates match 2
Lookup the date associated with a given value 2

Back
Top