Determine financial year and assessment year in excel from a date

-

Get the Financial / Assessment year from a date

get financial 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.

  1. 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.

  1. 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 simply enter =AY(B2) in cell D2. The result will be 2024-25.

Incorporating the free FY/AY" add-in into your Excel improves your working by ensuring precise calculations of financial and assessment years. This small but powerful tool streamlines your workflow and improves accuracy, making your financial analysis more efficient and reliable.
Get AY from a date in excel

How to Add the "FY/Ay" Add-In to Excel
  • Download the free excel Add-In the "Get FY/AY"  file from here.
  • Open Excel >  Go to the File menu and select Options. > In the Excel Options window, select Add-Ins from the sidebar. > Load the Add-In:

  • At the bottom of the Add-Ins window, select Excel Add-ins from the Manage dropdown and click Go.

  • In the Add-Ins window, click Browse and navigate to the location where you saved the "FY/AY" add-in file. >Select the file and click OK. >Enable the Add-In:
Alternatively, go to the Developer menu, click Excel Add-Ins, then click Browse and OK. Ensure AY/FY add in is appear in list and is selected. as appear in this image.

Get ay from date vba
Pro-tip: if you want to add prefix FY to year use FYR instead of FY formula. Same for AY . E.g. with FYR you will get "FY 2023-24", with AYR you will get " AY 2024-25"..

Download: Add-in
If you wish to get VBA code instead of add-in you can get it here: VBA
#Freeexceladdin #freeadin #getfy #exceltips

-----------------------------------------------
Disclaimer: This Excel add-in has been created with the intent to improve your workflow and automate specific tasks. However, by downloading and using this add-in, you agree that you do so at your own risk. We have taken care to ensure the add-in works correctly, but there is always a possibility of unexpected errors, data loss, or file corruption. We cannot be held responsible for any damages or issues arising from the use of this add-in. Before using the add-in, ensure your data is backed up and always exercise caution when automating tasks in Excel. 

Comments

Post a Comment

Popular posts from this blog

PF payment due dates for the FY 2020-21 for tax audit reporting

-
Image
PF payment due dates for the FY 2020-21 for the purpose of tax audit reporting While preparing Tax Audit Report in Form 3CD it is important to fill due date of payment to various Employees contribution fund and actual payment of the contribution. i.e  "Details of contributions received from employees for various funds as referred to in section  36(1)(va)" Most commonly reported funds under the clause are EPF and ESIC. If there is delay in the payment of the contributions of PF and ESI may result in disallowance of the payment of contribution. Here is the chart of the due dates under EPF and ESIC for the FY 2020-21 for quick reference  PF payment due dates for the FY 2020-21 Period Due date Day Extended date Reference Apr-20 15/05/2020 Friday                                -                           -   May-20 15/06/2020 Monday                  
Continue Reading

PF payment due dates for the FY 2021-22 for reporting u/s 36(1)(va)

-
Image
PF payment due dates for the FY 2021-22 for the purpose of tax audit reporting Reporting under clause 20 (b) of Form 3CD requires due dates of payment to various Employees contribution fund. i.e  "Details of contributions received from employees for various funds as referred to in section  36(1)(va) " Here " due date " means the date by which the assessee is required as an employer to credit an employee's contribution to the employee's account in the relevant fund under any Act, rule, order or notification issued thereunder or under any standing order, award, contract of service or otherwise. Most commonly reported funds under the clause 20(b) are EPF and ESIC. If there is delay in the payment of the contributions of PF and ESI result in disallowance of the payment of contribution. Here is the chart of the due dates under EPF and ESIC for the FY 2021-22 for quick reference. PF payment due dates for the FY 2021-22 Period Due date Day
Continue Reading

Format of shorter notice consent for AGM (Annual General Meeting)

-
Image
Format of shorter notice consent for AGM (Annual General Meeting) Background The Companies Act mandates companies to issue a notice to members calling a general meeting at least 21 clear days before the date of the meeting. Sometimes, the matters in urgency require quick decision making and in such circumstances, the companies may go for calling general meetings at shorter notice. However, in case of the private limited companies the period can be less than 21 days as provided in the Articles of Association (AOA). Provision and Rule As per the provisions of Section 101 (1) of the Companies Act, 2013, every general meeting of a company may be called by giving not less than twenty-one days clear notice in writing or through electronic mode in such manner as provided under Rule 18 of Companies (Management and Administration) Rules 2014. What is Consent for shorter notice? It is permission obtained by the company from its shareholders, in advance, to call a general meeting at an earlier da
Continue Reading

PF payment due dates for the FY 2022-23 for reporting u/s 36(1)(va)

-
Image
PF payment due dates for the FY 2022-23 for the purpose of tax audit reporting Reporting under clause 20 (b) of Form 3CD requires due dates of payment to various Employees contribution fund. i.e  "Details of contributions received from employees for various funds as referred to in section  36(1)(va) " Here " due date " means the date by which the assessee is required as an employer to credit an employee's contribution to the employee's account in the relevant fund under any Act, rule, order or notification issued thereunder or under any standing order, award, contract of service or otherwise. Most commonly reported funds under the clause 20(b) are EPF and ESIC. If there is delay in the payment of the contributions of PF and ESI result in disallowance of the payment of contribution. Here is the chart of the due dates under EPF and ESIC for the FY 2022-23 for quick reference. PF payment due dates for the FY 2022-23 Period Due Date Day Extended D
Continue Reading

Letter of Authority for Tax Practitioners (Income tax)

-
Image
LETTER OF AUTHORITY I/We ________________ Proprietor/Partner/Director of _______________________ hereby authorize Mr/Mrs/ CA __________________________ [   to appear, represent and settle on my/our behalf the Income tax assessment proceeding/s before the Income tax officer / Assistant/Dy. / Commissioner of Income tax or in appeal before the Appellate Assistant Commissioner of Income   Tax, Commissioner of Income tax (Appeal) or the Appellate tribunal or the Board of Direct taxes for the assessment year 20XX-XX and   [ to produce accounts and documents / statements and to receive on my/our behalf any notice or documents / statements issued in connection with the said proceedings ] or/and [ to apply for, obtain and receive refund order in respect of the said assessment (if any) and ] or/and [ to apply for copies of the Income tax assessment order, the Appellate order or the order of the Commissioner of Income tax, the Central Board of Direct-taxes ] . I/
Continue Reading