|
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. :mad: Heeeeeeeeelp! -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
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. :mad: Heeeeeeeeelp! -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
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 |
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. :mad: Heeeeeeeeelp! -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=560409 |
| All times are GMT +1. The time now is 08:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com