Forum Discussion
Deduct week numbers in Excel
I want to deduct week numbers in Excel but I don't know the formula (it should be something easy but I don't know) For example in cell A1 I have 01.2019 (so this mean week 1 from 2019) and I want to...
Hi Ilker,
With data like this
assuming you keep Week.Year as text, formula could be
=(MOD(INT(A2)+B2-1,52)+1) &"."& (MOD(A2,1)*10000+INT(B2/52))