"If in last week" formula

[oatmeal]

I have a number of simple two column sheets, one column contains dates.
Basically each sheet is an employee, and the items list the date and
notes for any "one on one meetings" that I have with that employee. I
want to have a summary sheet that lets me know when the most recent
meeting was.

I think it would be ideal to check sheet1-5, if date is older than 1
week, output false or true.

I can't find any formula example on the net that uses dates as a
condition of true or false. Can anyone point me in the right direction?

[Bryan Hessey]

Does

=IF(A1<(TODAY()-7),true,false)

work for what you need?

I have a number of simple two column sheets, one column contains dates.
Basically each sheet is an employee, and the items list the date and
notes for any "one on one meetings" that I have with that employee. I
want to have a summary sheet that lets me know when the most recent
meeting was.

I think it would be ideal to check sheet1-5, if date is older than 1
week, output false or true.

I can't find any formula example on the net that uses dates as a
condition of true or false. Can anyone point me in the right direction?

[oatmeal]

Yes that does work to an extent, thank you. The trouble is that is only
for one cell. I tried modifying it to:

=IF(A3:A30<(TODAY()-7),TRUE,FALSE)

or

=IF((A3:A30)<(TODAY()-7),TRUE,FALSE)

but neither of those work. I need it to check the entire column, and if
one of the dates is less than a week old, spit out true. It seems to be
adding them together or something.

-Steven


Bryan Hessey wrote:
> Does
>
> =IF(A1<(TODAY()-7),true,false)
>
> work for what you need?
>
>
>
> oatmeal Wrote:
> > I have a number of simple two column sheets, one column contains dates.
> > Basically each sheet is an employee, and the items list the date and
> > notes for any "one on one meetings" that I have with that employee. I
> > want to have a summary sheet that lets me know when the most recent
> > meeting was.
> >
> > I think it would be ideal to check sheet1-5, if date is older than 1
> > week, output false or true.
> >
> > I can't find any formula example on the net that uses dates as a
> > condition of true or false. Can anyone point me in the right direction?
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=471990

[Cutter]

Try:

=MAX(A3:A30)>TODAY()-7

You don't need an IF() function when all you're looking for is a TRUE or FALSE answer

This will give a TRUE result if the most recent date in your range is less than 7 days old and a FALSE result otherwise

[Domenic]

Try...

=IF(COUNTIF(A3:A30,"<"&TODAY()-7),TRUE,FALSE)

Hope this helps!

In article <[email protected]>,
"oatmeal" <[email protected]> wrote:

> Yes that does work to an extent, thank you. The trouble is that is only
> for one cell. I tried modifying it to:
>
> =IF(A3:A30<(TODAY()-7),TRUE,FALSE)
>
> or
>
> =IF((A3:A30)<(TODAY()-7),TRUE,FALSE)
>
> but neither of those work. I need it to check the entire column, and if
> one of the dates is less than a week old, spit out true. It seems to be
> adding them together or something.
>
> -Steven

[oatmeal]

Thanks to Cutter, all is working fine now. Your little formula worked
without any modifications.

Thanks to all for their help on the matter. Kudos to this group!

[Cutter]

You're welcome. Glad to help.