Exclude Sunday while adding days to a given date

Dear Excelsmart people,

I have an invoice date to which I have to add 14 days to get the payment day of invoice, in such way that all Sundays are excluded from 14 days counts.

Example invoice date is 11aug18 + 14 days grace period, payment would 27Aug18.

Can you people help me with a formula that give the 14th days payment date without counting Sundays.



Thanks and regards

Santosh Mekale

If your date is in A1 then

Formula:

Please Login or Register  to view this content.

You will always have two sundays in your 14 days regardless of whichever day of the week you start with so you need to add two days.

But if you start on a Friday or a saturday, those two days will land on a sunday, so you need to add one more day.