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 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.
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.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks