Day of the week in a year

[Juggler_IN]

I want to compute the value for the "day of the week in a year." For example, Today (7th August) is Friday number 32 out of 52 Fridays in 2020. How do I get this value using a UDF?

 

[gaz_chops]

If a formula is acceptable, you can try

=WEEKNUM(A1)

You can tweak as to when the year starts/week starts.

 

[Fluff]

Duplicate Day of the week in a year

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).