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.
|