Good day,
I don't have any problems when I'm counting how many weeks between two dates when they are in the same year.
Example
A1: Inception Date:
A2: Completion Date:
B1: 5/2/2014
B2: 11/6/2014
B3: = WEEKNUM(B2) - WEEKNUM(B1)
if I replace a date in cell B2 like 3/5/2015 it returns a negative value (-8) because the completion date is on the next year already. Can you help me sort it out? Thanks in advance!!
Bookmarks