formual to determine if date falls on weekend, adjust date to Mond
Hi,
Suppose your end date is in cell B1 then
=B1+IF(WEEKDAY(B1,2)=6,2,IF(WEEKDAY(B1,2)=7,1,0))
Calculated the ending date after any necessary adjustments for the weekend.
A shorter version is
=B3+IF(MOD(B3,7)=0,2,IF(MOD(B3,7)=1,1))
If this helps, please click the Yes button
cheers,
Shane Devenshire
"Bradley" wrote:
Hi I am using excel to show project timeline. I want to determine if the day
falls on saturday or sunday. If the day of week falls on the weekend I will
add the appropriate number of days to bring the new date to the start of the
work week.
basically I have a cell with my starting date, then add the number of days
of work expected and get an ending date. if the ending date falls on a
weekend then I want to adjust the ending date appropriately.
for example;
if (day=saturday) day=day+2
if (day=Sunday_)day=day+1
thanks for your help
Bradley
|