If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If date in range is before today
Hi All,
I'm getting #VALUE! with this formula. =IF('AP-AR'!B43:'AP-AR'!B297TODAY(),"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
|
|||
|
|||
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'!B297TODAY(),"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
|
|||
|
|||
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'!B297TODAY(),"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
|
|||
|
|||
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'!B297TODAY(),"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. |
Thread Tools | |
Display Modes | |
|
|