cancel
Showing results for
Did you mean:
Helper II

## Add 28 working days to a date in SharePoint list?

Hello all

I'm new here and despite searching, cannot find an answer to what I think must be relatively simple. I have a list which includes 2 date columns. The first is "Date 28-day letter issued" and the second "28-day letter expiry date" I need to work out how to add 28 working days (Monday to Friday) to the first date in order to give me the expiry date in the second column. Could anyone help please? Thank you in advance!

Super User

You might find this post useful. It talks about calculating the number of working days between two dates. https://sharepoint.stackexchange.com/questions/197827/calculate-number-of-working-days-between-two-d...

It suggests using this formula

``````IF(ISERROR(DATEDIF([StartDate],[EndDate],”d”)),””,(DATEDIF([StartDate],[EndDate],”d”))+1-INT(DATEDIF([StartDate],[EndDate],”d”)/7)*2-IF((WEEKDAY([EndDate])-WEEKDAY([StartDate]))<0,2,0)-IF(OR(AND(WEEKDAY([EndDate])=7,WEEKDAY([StartDate])=7),AND(WEEKDAY([EndDate])=1,WEEKDAY([StartDate])=1)),1,0)-IF(AND(WEEKDAY([StartDate])=1,(WEEKDAY([EndDate])-WEEKDAY([StartDate]))>0),1,0)-IF(AND(NOT(WEEKDAY([StartDate])=7),WEEKDAY([EndDate])=7),1,0))
``````

Announcements