|
Extracting Dates
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 |
Extracting Dates
=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 |
| All times are GMT +1. The time now is 02:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com