0

I have a SharePoint list with start date and end date. I also have 12 calculated columns for each month - Jan to Dec. I want to calculate these columns so that they display working days between start date and end date by each month. For e.g. for start date : 1/1/2023 | end date : 5/31/2023

I want columns to have data as Jan : 22 Feb : 21 Mar : 22 Apr : 22 May : 21 June : 0 ... Dec : 0

Can someone help with formula for the same ? i have tried and found business days between start date and end date but not by each month.

1 Answer 1

0
=(TEXT([DateColumn1],"mm")-(TEXT[DateColumn2],"mm"))

That should give you the difference between the months for 2 date fields.

1
  • this did not work.
    – Tejas
    Oct 6, 2022 at 16:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.