Hi
I am looking for a formula to show the first day of a fiscal year which starts on 01/09 each year. I have column A with a list of various dates i.e. 11/10/2020 and I want column B to show the first day of the fiscal year i.e 01/09/2020. I also need the result to be in a date format dd/mm/yyyy
I have tried DATE(YEAR(a5)+(MONTH(a5)>9),9,1) but this seems to show the end date
I am looking for a formula to show the first day of a fiscal year which starts on 01/09 each year. I have column A with a list of various dates i.e. 11/10/2020 and I want column B to show the first day of the fiscal year i.e 01/09/2020. I also need the result to be in a date format dd/mm/yyyy
I have tried DATE(YEAR(a5)+(MONTH(a5)>9),9,1) but this seems to show the end date