I have two formula columns, both pointing at one date field (“Date”). The formulas in the two fields are:
For some reason, the week number in the WEEKNUM column is always 1 more than in the DATETIME column. So if the DATETIME column translates the week as 11, the WEEKNUM column translates it as 12 and so on.
Does anyone know why the week numbers are not lining up?