Comparing like for like with a 53 week year

S

sarahds

we report data on a weekly basis, with the week ending on a Tuesday.
We chart the data to show like for like comparisons with same weeks
previous years. How do I enter the data to show a 53 week year (Leap)
to compare with a 52 week year?
 
B

Bob I

The difference between a Leap year and a regular year is 1 day (365 vs
366) not one week.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condensing part of the X-Axis Excel 2007 charts 3
Year + week => first date of week 9
Current year and current week number 11
Year and Week Totals 2
need help writing a script Hiding a range when a cell with in is greater than 53.. 1
Formula for calculating target hours against actual hours 12
Number of weeks in 2009 / ISO 8601:2004 2
need help with Formula 1

Top