| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return info based on Date Range
I need to have a date returned based on a date range. Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place the date of A1 into cell B6. But I don't understand how to input a date range into Excel.  Heeeeeeeeelp! -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return info based on Date Range
Try the following formula in B6
=IF(AND(A1=DATE(2006,1,1),A1<=DATE(2006,31,1)),A1 ,"no") Be sure to format B6 for a date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kermitforney" wrote in message news:kermitforney.2asnt5_1152643510.8615@excelforu m-nospam.com... I need to have a date returned based on a date range. Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place the date of A1 into cell B6. But I don't understand how to input a date range into Excel. Heeeeeeeeelp! -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return info based on Date Range
Type the date 1/1/2006 and 1/31/2006 in 2 cells say B1 and B2 =IF(AND(A1B1,A1<B2),A1,"") This returns a blank if the date in A1 does not meet the criteria. If you don't want to use cell references you could use: =IF(AND(A1DATEVALUE("1/1/2006"),A1<DATEVALUE("1/31/2006")),A1,"") HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return info based on Date Range
=IF(AND(A1=DATE(2006,1,1),A1<=DATE(2006,31,1)),A1 ,"no")
should be =IF(AND(A1=DATE(2006,1,1),A1<=DATE(2006,1,31)),A1 ,"no") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... Try the following formula in B6 =IF(AND(A1=DATE(2006,1,1),A1<=DATE(2006,31,1)),A1 ,"no") Be sure to format B6 for a date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kermitforney" wrote in message news:kermitforney.2asnt5_1152643510.8615@excelforu m-nospam.com... I need to have a date returned based on a date range. Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place the date of A1 into cell B6. But I don't understand how to input a date range into Excel. Heeeeeeeeelp! -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Counting unique records based on date range | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| overtime formula based on dynamic date range? | Excel Worksheet Functions | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
Linear Mode
