getting the current week number formula

**Kezwick** · 10-20-2011, 06:51 AM

hey guys a easy one for you guys
i need to get the week number to populate a cell when i open the file so if it for example today (20 october) would be week 42
there is a formular for it but u have to manually put in the day of the year if theres a way to get the day auto then perfect either will work
Many thanks

**arthurbr** · 10-20-2011, 06:53 AM

try =weeknum(today(),2)

**tom1977** · 10-20-2011, 06:54 AM

try this (short one)

**daddylonglegs** · 10-20-2011, 07:02 AM

Tom's formula is giving you the "ISO week number" - which makes today in week 42. Even shorter formula for that

=INT((A1-WEEKDAY(A1,2)-DATE(YEAR(A1+4-WEEKDAY(A1,2)),1,4))/7)+2