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
Search JabSto ::




Custom Search