I want Excel to return a week number for a specific date

[PGFamilyMan]

I want Excel to return a value of 1,2,3,4, or 5 denoting that a specific date is the 1st, 2nd, 3rd, 4th, or 5th day of the month. For example. I'd like to enter "11/22/2023", and then have the adjacent column return a '3', meaning that it's the 3rd Wednesday of the month. I know how to return 'Wednesday", but how do I return specifically the THIRD Wednesday?

 

[Fluff]

How about

=INT(DAY(A2)/7)+1

Also the 22nd Nov 23 was the 4th Wednesday.

 

[PGFamilyMan]

that's why i need the formula!

that was easier than I thought. Thanks!

 

[PGFamilyMan]

On second thought... this isn't working. I'm using this formula for '6/7/2023', and it's showing a '2'. This date is the 1st Wednsday, so I'd want it to return a '1'.

 

[Fluff]

How about

=INT((DAY(A2)-1)/7)+1

 

[PGFamilyMan]

I think you've got it. It works for 2023 anyway. Thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.