latest date of fiscal year 2021

[ashmitp869]

Hi there,

How to set variable and get today() Financial Year end

i.e Today is 18/05/2021 

so my result req is 30/06/2021 .

I am setting the variable as below but giving me 31/05/2021

SET vCurrentFYEnd ="=(Date(MonthEnd(Max(Today())),'D/MM/YYYY'))";

[nsm1234567 · Accepted solution]

Hey there,

Your code is giving you the current month's monthend. 

There are a lot of ways to calculate the financial year end.  One way would be the following:

 =YearEnd(Today(0), 0, 7)

In the above case, you're using the YearEnd Function to return the YearEnd assuming that the year starts in July.