Calculate number of months per Fiscal Year.

Copper Contributor

The Fiscal Year runs through 07/01/xx and 06/30/xx. I need to show the number of months by Fiscal Year. 

3 Replies

@amandaramos 

What do you want to return for partial months, such as a project that starts on the 15th of August or ends on the 12th of October?

Hi @Hans Vogelaar, if the start date is 08/15/2020 and the project end date is 10/12/2021, it would be 3 months for FY21 and 9 months for FY22

@amandaramos 

Can you explain how that works? I don't understand, sorry.