Convert date in Financial Year using Function created in vba,Enable Function To Work in all workbook

Convert date in Financial Year by using FUNCTION created in Excel VBA, for e.g. 01-Apr-2019 into 19-20 or 15-Jan-2019 into 18-19 and also enable the function to work in all excel workbooks/ files by saving / activating function using Excel Add-ins

Step 1. Copy the below VBA Function
Step 2. Create a new sheet, go to VBA editor and insert a new module
Step 3. Paste the copied function in the module
Step 4. Change the bold text given in the line three with greater than & less than sign
Step 5. Test the function (currently it is available in the current active workbook only)
Step 6. To enable the function to work on all the workbooks, save as your file with excel file type Excel Add - in (.XLAM)
Step 7. Click on file menu and go to the option, then select Add - Ins, after selecting add-ins, you will find multiple function available there, select the FinYear1 Function and then click on the Go button
Step 8. A pop up windows will option with few function, you need to selection the FinYear1 Function and then click ok
Your Function is ready to use in all workbooks / Excel files
Function finyear1(cell As Date) As String
If (Application.WorksheetFunction.And(Month(cell) "is greater than"= 1, Month(cell) is less than = 3) = True) Then
'angle brackets are not allowed to paste here hence request you to change the above bold text with angle brackets as per the text

finyear1 = (Application.WorksheetFunction.Text(cell, "yy") - 1) & "-" & Application.WorksheetFunction.Text(cell, "yy")
Else
finyear1 = Application.WorksheetFunction.Text(cell, "yy") & "-" & (Application.WorksheetFunction.Text(cell, "yy") + 1)
End If
End Function

Link of My Videos

How to create a personal workbook so that a macro can run on any excel files without saving as macro enabled workbook
Consolidate multiple workbooks / excel files into one excel workbook
Copy files and folder names using command prompt
Copy files and folder name in an excel file using VBA Excel MACROS
Count duplicate value using if and sort function in a very large excel data
Top 5 shortcut key used in Excel
Count duplicate value using countIF Function
How to split one single big file into multiple small files in size so to enable to send it through email
How to reduce file size even better than zip filing using zipx option of WINZIP
How to merge multiple sheets into one excel sheet
How to delete a sheet using MACRO
How to create a Macro to add a new sheet automatically
How to create a password protected excel file
Create your first Macro in Excel VBA
How to use IFERROR Function with Vlookup Function
Use of Hlookup Function
Use of Vlookup Function
Use of Lookup Function
Create multiple files from a single file based on a criteria using macros in excel VBA
MID Function - Extract number / words from a dynamic position / position not fixed
Change date format using Text Function
How to protect rows or columns - Allow edit range allows you to edit only selected ranges in Excel
Concatenate function used with text function, joins two or more text / numbers into one
Text Function - change the way a number /text / date appears
How to use Subtotal function to count visible cells only in a given range
Use of Subtotal function to sum / total of all visible cell in a given range
Use of Dollar Sign/ How to use $ Sign, Freeze rows or column and both
How to console / Merge multiple text files into one text file using command prompt / DOS / CMD
How to use SUMIFS function, sums a selected range with multiple criteria's / conditions
How to create aging / Bucketing using IF Function in excel
SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
How to create aging / Bucketing using IF Function in excel
SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
Use of Countif Function - How to count cells in a range with a condition / Criteria