Calculate number of months from date excluding Sundays

Good afternoon

Is it possible to calculate 6 months from a date excluding Sundays?

I have used the =EDATE(A1,6) function to return 6 months from the date with no problem, however can I add in for the function to exclude Sundays?

Thank you.

Good morning

It is for a pay calculation, so in my organisation Sundays are not counted as a working day (don't ask me why!).

I suppose what I would like is to calculate exactly 6 months (in calendar days) from a date, then subtract any day that is a Sunday within that 6 month period.

Thank you.

This will give you number of working days in 6 month calendar period excluding Sundays:

=NETWORKDAYS.INTL(A1,EDATE(A1,6),11)

A1= Start date

Does this help?

Hi John

Thank you for the reply. Your formula above is great however it is not producing the date I would expect. I suspect I haven't explained myself properly so if I could clarify a little further.

Our organisation gives 156 days sick pay entitlement. So if an individual goes sick on the 1/1/17, I need excel to calculate 156 days from 1/1/17 to give me the date their pay should drop, but 'skip' Sundays. So 1/1/17 +156 = 6/6/17, however I would expect the date the pay drops to be around the end of June if Sundays are not included in the calculation.

Thanks again.

Try

=WORKDAY.INTL(A1,156,11)

A1= 01/01/2017

Result is 01/07/2017