# Formula to calculate the date of the first Saturday in July

1. ## Formula to calculate the date of the first Saturday in July

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?

2. ## Re: Formula to calculate the date of the first Saturday in July

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

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Formula to calculate the date of the first Saturday in July

Or try:

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

4. ## Re: Formula to calculate the date of the first Saturday in July

Or:

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

5. Originally Posted by hrlngrv
if you have the 1 july date in some year in cell d3, try

Formula:
`Please Login or Register  to view this content.`
thank you so very much!

6. Originally Posted by Phuocam
Or try:

=WORKDAY.INTL(B2-1,1,"1111101")
Thank you so very much

7. Originally Posted by AliGW
Or:

=WORKDAY.INTL(DATE(2020,7,1),1,"1111101")
Thank you so very much

8. ## Re: Formula to calculate the date of the first Saturday in July

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)