I am trying to get Excel to return the date of thr first Saturday in July based on a starting date for the fiscal tax year beginning 1 July each year. Obviously, the date of the FIRST SATURDAY will varie from year to year. Try as I might I can't seem to get a formula that is consistently correct for the year in question.
I have the date of the start of the fiscal tax year entered in cell b2 (e.g 1/7/20) [using dd/mm/yyyy format]
I want the DATE of the first Saturday in July, based on that date - this is needed to calculate and display weekly tax liabilities.
Can anyone help me with this?
Bookmarks