# Calculate number of months from date excluding Sundays

1. ## 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.

2. ## Re: Calculate number of months from date excluding Sundays

Not sure what excluding Sundays means. If the start date is Monday, April 3, 2017, one month later is May 3, 2017 (Tuesday) whether you exclude Sundays or not. Are you saying if the result is a Sunday, then make it a Monday instead?
Do you want to count 30 days between dates but don't count Sundays? Please clarify.

3. ## Re: Calculate number of months from date excluding Sundays

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.

4. ## Re: Calculate number of months from date excluding Sundays

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?

5. ## Re: Calculate number of months from date excluding Sundays

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.

6. ## Re: Calculate number of months from date excluding Sundays

Try

=WORKDAY.INTL(A1,156,11)

A1= 01/01/2017

Result is 01/07/2017

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1