Re: Calculate Next Due Date based on End of Quarter

To clarify what I am trying to do.

I have a previous due date and I have a next quarter due date.  What I need to do is if the Previous due date is 03/31/2021 then the next quarter due date needs to be 06/30/2021.  This formula works up until I put a future date like 01/01/2022 and then it returns blank.

//Calculate the quarter end dates

If(
[Previous Quarter Date]<(ToDate("3/31/" & (Year(Today())))),ToDate("3/31/" & Year(Today())),
[Previous Quarter Date]<(ToDate("6/30/" & (Year(Today())))),ToDate("6/30/" & Year(Today())),
[Previous Quarter Date]<(ToDate("9/30/" & (Year(Today())))),ToDate("9/30/" & Year(Today())),
[Previous Quarter Date]<(ToDate("12/31/" & (Year(Today())))),ToDate("12/31/" & Year(Today()))

------------------------------
Sandralee Oster
------------------------------