Tryting to assign each week a number

C

Cher

Hi,
If I'm in the week of May 4 and I'm trying to add 13 or 26 or 52 weeks, how
can I create a spreadsheet or formula to do this for me. Can the date be a
formula that I add seven day cycles to? I can only perform simple formulas
and this is a bit beyond me, but I'm sure it can be done, just don't know how.
 
J

Jacob Skaria

A1 = Date
The below formula will assign the weeknumber 1-52.
=WEEKNUM(A1)

If this post helps click Yes
 
Top