Link to home
Get AccessLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

Checking dates to see if they are less than 60 days apart - Excel 2007

I have a file which is sorted my ID.  I would like to check each ID to see if the member has any claims within 60 days of the prior claim (same date does not count),  If they do  I would like to put a "1" in column  "F".  Attached is a sample file.

Is there a way I can do this?
Ck-Frequency.xlsx
Avatar of skrga
skrga
Flag of Croatia image

=IF(C2<TODAY()-60;1;"")
ASKER CERTIFIED SOLUTION
Avatar of Brian B
Brian B
Flag of Canada image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Hi,

See attached.

I changed the date in the yellow cell to demonstrate it putting a 1 in col F.

Alan.
Ck-Frequency---Version-1.xlsx
Hi,

Sorry, forgot to mention that the formula in col F is an array formula.

When editing it, you need to re-enter it with Shift-Ctrl-Enter (but don't type in the {} braces - excel adds those when you do Shift-Ctrl-Enter.

Alan.