Hope you are well. Please assist me with the date calculation in Column E and Column F. The 2012/02/29 date should show (29) because for tax purposes it is a leap year. The leap years are 2012, 2016, 2020, 2024, 2028,2032,2036. The FYS for all taxpayers will start on 2010/03/01 and that specific tax year will end on 2011/02/28. The next tax year will start on 2011/03/01 and ends on 2012/02/28 + 1 to accommodate leap year.
Thank you in advance.
Thank you so much this is amazing.
Is there maybe a way to enter a formula that I can just drag down to the rest of the years? I need to do it for FYS 2010 to 2025.
Thank you for the help I appreciate this so much.