weeknum

[HRGuru55]

Trying to format cells to identify week number across the top of a spreadsheet.  Starting in column P

WEEKNUM(DATE(2021,1,(P1+7))) will identify column Q as week 2, but then stops increasing...  any ideas?

[#2]

@HRGuru55 

What does P1 contain?

[#3]

WEEKNUM(DATE(2021,1,1))

[#4 · Accepted solution]

@HRGuru55 

Best to use two rows: one for the dates and one for the week numbers.

In P1, enter 01/01/2021.

In Q1, enter the formula =P1+7

Fill to the right from Q1 as far as you want.

In P2, enter the formula =WEEKNUM(P1)

Fill to the right from P2 until you reach the last date in row 1.

Alternatively, just enter the series 1, 2, 3, ... in row 1 <grin>

[#5]

thanks, that works