morinia
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
Is there a way I can do this?
Ck-Frequency.xlsx
=IF(C2<TODAY()-60;1;"")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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.
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.