Microsoft Office Tutorials and References

In Depth Information

**Alternative Calendar Systems and DAYS360**

Figure 11.43.

Figure 11.43.
Excel 2013 offers better ways to calculate week numbers.

Excel 2013 offers better ways to calculate week numbers.

Alternative Calendar Systems and

Alternative Calendar Systems and
DAYS360

DAYS360

You might have to work with many alternative calendar systems in Excel.

Here are some examples:

•
Manufacturers often redefine a quarter as being composed of 13

workweeks, with the first 4 weeks being called Month 1, the next 4

weeks being Month 2, and the final 5 weeks being Month 3. This is known

as a 4-4-5 calendar.

•
Retailers use a special retail calendar composed of 52 seven-day

weeks. Each week ends on a Sunday. If you compare Week 7, Day 6 of one