| Home |
| Search |
| Today's Posts |
|
#4
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 |
| 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) | |||
Threaded Mode
