If date in range is before today

M

mjones

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
 
T

T. Valko

Try it like this...

=IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","")
 
T

T. Valko

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Try it like this...

=IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","")
Click to expand...

Perfect. You're great! Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I think it is a lookup question??? 6
Vlookup across 3 worksheets 2
Trouble with dynamic named range 4
Formula to count age by month 2
Get value in last non-zero value cell in column 5
* In IF Statement 4
Date sensitive calculation refresh 6
Multiply Corresponding Values in Range 3

Top