gellis

Custom Function - Calculate date of first date of next quarter

Discussion created by gellis on Aug 30, 2015

I am trying to create a custom function of given a date, I would like it to determine if this week of fiscal year number is within the first week of quarter else it will calculate the first date next quarter. Our Fiscal year starts on July 30

Also here is the initial CF I was working with from Brian Dunnings site.

 

https://www.briandunning.com/cf/147

 

Thanks in advance

Outcomes