Jan
16
Converting Date to Fiscal Calendar Date in Excel
This is a follow up post to Fiscal Calendar Calculations Cheatsheet for Tableau.
Excel is a very important tool for data analysis and calculations. It's also an important data repository for Tableau.
Converting Date to Fiscal Calendar Date in Tableau
Week-based calendars are used in many companies as their fiscal calendars. The total weeks in a fiscal year is 52 weeks, that is, 364 days. Each quarter has 13 weeks. There are 3 varieties of 13 weeks: 5-4-4, 4-5-4 and 4-4-5 weeks per quarter. In leap years, there are 53 weeks or 371 days.
