84
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!
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-dates
It suggests using this formula
Share
Report
All responses (
Answers (
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))
