| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If date in range is before today
Hi All,
I'm getting #VALUE! with this formula. =IF('AP-AR'!B43:'AP-AR'!B297<TODAY(),"AP-AR needs updated","") I've probably made a right mess of it, but what I'm trying to do is make the cell say 'AP-AR needs updated' if there is any date less than today in the range from B43 to B297 on the AP-AR worksheet. The cell is general format. Any help would be really appreciated. Thanks again, Michele |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show blank when today() is within a certain date range | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| Sum a range of cells starting from an offset date list from TODAY() | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
Threaded Mode
