Weeks of 2023 calculating incorrectly

Hollie Green

Using the same formula I used for 2022.

=IF(WEEKDAY(DATE(Year@row, 1, 1) + Week@row * 7) = 2, DATE(Year@row, 1, 1) + Week@row * 7, (DATE(Year@row, 1, 1) + Week@row * 7) - (WEEKDAY(DATE(Year@row, 1, 1) + Week@row * 7) - 2))

Results for 2022 come back correct for week 1 but for 2023 comes back with the date that should be for week 2

Samuel Mueller

@Hollie Green what are you trying to achieve? That formula you have written is returning the correct date based on how it's written, so you would need to change the formula.