I have a formula below , where I need the week number from 1 - 13 depending on the upload date & what Qtr we are in.
=WEEKNUM(J4058)-WEEKNUM(LOOKUP(J4058,DATE(YEAR(J4058),{3,6,9,12},30)))
When a new QTR starts, the weeknum should be "1", however it keeps populating as "0".
Any help would...