Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
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=545875 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
If a date is in A1 then:
=IF(DAY(A1)<13,"bad","good") -- Gary's Student "nandin11" wrote: 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=545875 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
Hi, Thank you for your reply. Something does not seem to be working and I am sure it's an oversight on my part. I have 11-Jan-67 in E2 and 14-Jan-67 in G2 and in H2 =IF(DAY(E2<12),G2,E2) and yet it still returns the value of 11-Jan-67. Is there some special formatting I should follow? Thank you. -- nandin11 ------------------------------------------------------------------------ nandin11's Profile: http://www.excelforum.com/member.php...o&userid=34840 View this thread: http://www.excelforum.com/showthread...hreadid=545875 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
We are almost the
=IF(DAY(E)<12,G2,E2) not =IF(DAY(E2<12),G2,E2) -- Gary's Student "nandin11" wrote: Hi, Thank you for your reply. Something does not seem to be working and I am sure it's an oversight on my part. I have 11-Jan-67 in E2 and 14-Jan-67 in G2 and in H2 =IF(DAY(E2<12),G2,E2) and yet it still returns the value of 11-Jan-67. Is there some special formatting I should follow? Thank you. -- nandin11 ------------------------------------------------------------------------ nandin11's Profile: http://www.excelforum.com/member.php...o&userid=34840 View this thread: http://www.excelforum.com/showthread...hreadid=545875 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Intervals | Excel Worksheet Functions | |||
Extracting Dates | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
date formula for extracting unique dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |