How to know the nth (1st, 2nd .... 5th) occurrence of a particular day?

Hi,

How to know the nth occurrence of a particular day of week is either 1st, 2nd, 3rd, 4th or 5th in a month of a given date ?

e.g.
IF cell A2 = 29-May-2020 (5th occurrence of Friday) Then B2 should return =5 and 15-May-2020 = 3rd Occurrence of Friday in May month likewise.

Thank you in advance !

Try this

Please Login or Register  to view this content.

Thank You @huuthang_bd for your help!

stay blessed!