Quarter creation based on Friday

[prakashij_25]

Team,

I have a requirement of creation customized Quarter field based on Date field. All Quarter should have 13 weeks and last week of Quarter should end with Friday. Also we are considering only Network days

Q1 2021-Started-01/04 ended with 04/02

Q222021 - Started - 04/05 ended 07/02

Q3 20201- Started - 07/05 ended 10/01

Q4 2021 - started - 10/04 ended 12/31

Any idea will be highly appreciated 

[Gysbert_Wassenaar]

Create your calendar in an excel file with quarters for the next ten (or more) years. Then load the calendar from the excel file.

[prakashij_25]

Hi,

Thank you for your kind reply. However it wont work in that way