Professional Updates

Get the Financial / Assessment year from a date While working in Excel on financial data, we often need to check the financial year (FY) and assessment year (AY) for transaction dates. With the " AY/FY " add-in, you can directly get the FY and AY from a date in Excel, streamlining your workflow and enhancing accuracy. The Free "FY/AY" excel add-in provides two custom functions, FY and AY, to quickly calculate the financial year and assessment year based on a given date . These functions simplify the process and enhance productivity. FY Function Purpose: Calculates the financial year for a given date. Usage: =FY(date) Example on FY Function: Suppose you have a date 15-May-2023 in cell B2: to get Financial Year for this date simply enter =FY(B2) in cell C2. The result will be 2023-24. AY Function Purpose: Calculates the assessment year for a given date. Usage: =AY(date) Example on AY Function: Suppose you have a date 15-May-2023 in cell B2: to get Assessment Year sim