B
Ben Greenwood
Can anyone help?
I have two columns with dates in them, and want to check
the first column (the "assigned" date) against the second
("completed" date) and have Excel respond true or false as
to whether the "completed" date is within 5 WORKING DAYS
of the "assigned".
Basically, I can't seem to make excel skip Saturdays and
Sundays in its calculations... certainly not in the IF
statement I'm currently using.
Any ideas?
Ben
I have two columns with dates in them, and want to check
the first column (the "assigned" date) against the second
("completed" date) and have Excel respond true or false as
to whether the "completed" date is within 5 WORKING DAYS
of the "assigned".
Basically, I can't seem to make excel skip Saturdays and
Sundays in its calculations... certainly not in the IF
statement I'm currently using.
Any ideas?
Ben