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

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

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.

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.

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