Calculate the Financial year for dates

Help StudioX
,
5

Hello @Amol_Golhar
Try this

  1. Read Excek file
  2. Use If Condition in For each datatale
If condition ---> Cdate(Currentrow("Invoice date")).Month>3

then

Currentrow("Financial Year")= Cdate(Currentrow("Invoice date")).Year

Else

Currentrow("Financial Year")= Cdate(Currentrow("Invoice date")).Year-1
  1. Write Range to write the data in excel File.

Other wise use Excel Formula. Refer to the Below thread
How to Get the Fiscal Year From a Date in Excel - That Excel Site).

1 Like