Formula to calculate the date of the first Saturday in July

[USAOz]

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?

[hrlngrv]

If you have the 1 July date in some year in cell D3, try

=D3-WEEKDAY(D3+8,3)+6

[USAOz]

if you have the 1 july date in some year in cell d3, try

=d3-weekday(d3+8,3)+6

thank you so very much!

[Phuocam]

Or try:

=WORKDAY.INTL(B2-1,1,"1111101")

[USAOz]

Or try:

=WORKDAY.INTL(B2-1,1,"1111101")

Thank you so very much

[AliGW]

Or:

=WORKDAY.INTL(DATE(2020,7,1),1,"1111101")

[USAOz]

Or:

=WORKDAY.INTL(DATE(2020,7,1),1,"1111101")

Thank you so very much

[AliGW]

You're welcome.