Exclude Sunday while adding days to a given date

[msantosh1220]

Hey Guys,

Can one help me with a formula that adds any number of days to a given date, while adds the number of days all the sundays should be excluded while generating the new date.

Example:
1. If the Given date is 12 Jul 18 I wana add 5 days to 12jul18 excluding sundays result date should be 18Jul18 as there is one Sundays in between 12 and 18jul18 which was excluded from d counts.
2. If the Given date is 9jul18 I wana add 5 days to 9jul18 result days should be 14jul18 their is no sunday in between 9 to 14jul18.


Please note I have data in which Given dates n days to be added are not fixed thy keep on changing.

Looking 4 answer tat could help me in getting d right that will exclude the Sundays in d counts



Thanks and regards

Msantosh1220

 

[Legacy 143009]

Hey Guys,

Can one help me with a formula that adds any number of days to a given date, while adds the number of days all the sundays should be excluded while generating the new date.

Example:
1. If the Given date is 12 Jul 18 I wana add 5 days to 12jul18 excluding sundays result date should be 18Jul18 as there is one Sundays in between 12 and 18jul18 which was excluded from d counts.
2. If the Given date is 9jul18 I wana add 5 days to 9jul18 result days should be 14jul18 their is no sunday in between 9 to 14jul18.


Please note I have data in which Given dates n days to be added are not fixed thy keep on changing.

Looking 4 answer tat could help me in getting d right that will exclude the Sundays in d counts



Thanks and regards

Msantosh1220

Have a nice day
=$A1+INT((WEEKDAY($A1-1)+($A1+5)-$A1)/7)

 

[Rick Rothstein]

Here is another formula for you to try...

=WORKDAY.INTL(A1,5,11)

The red 5 is the number of days to add (the 11 is the function's code value for Sunday only for weekends).

 

[msantosh1220]

Thankx 4 helping.

 

[msantosh1220]

Thankx it was easy n quick formula.