| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return TRUE if a date falls between two dates
just for some additional detail for what I am doing? I've used this
formula in each cell of a calandar so that tells me weekdays that I did not work (excluding wknds and holidays). "Rick Rothstein (MVP - VB)" wrote: =IF(SUMPRODUCT(--(StartD<=A5),--(EndD=A5)),"T","F") I wasn't entirely clear from Christine's posting which conditionals should be considered True and which False; but assuming she liked the results your formula yielded, I think this formula will work also.... =MID("FT",1+(StartD<=A5)*(EndD=A5),1) Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need true or false if a date falls between a date range | Excel Worksheet Functions | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Return a specified date when it falls within a range.... | Excel Discussion (Misc queries) | |||
| How to find if a date falls between 2 dates | Excel Worksheet Functions | |||
Threaded Mode
