| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If date in range is before today
Try it like this...
=IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","") -- Biff Microsoft Excel MVP "mjones" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If date in range is before today
On Jan 10, 11:55*pm, "T. Valko" wrote:
Try it like this... =IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","") -- Biff Microsoft Excel MVP "mjones" wrote in message ... 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 Perfect. You're great! Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If date in range is before today
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "mjones" wrote in message ... On Jan 10, 11:55 pm, "T. Valko" wrote: Try it like this... =IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","") -- Biff Microsoft Excel MVP "mjones" wrote in message ... 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 Perfect. You're great! Thanks. |
|
#5
|
|||
|
|||
|
Hey there, I have a similiar question that I can't figure out. I want to conditionally format cells w/ dates in them to fill red when the date becomes 1 month after "today" . . . and possibly fill red when the date becomes "today."
Any help would be sweet! -V |
| Reply |
| 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) | |||
Linear Mode
