Category: Excel Formulas

If you have a number and want to convert the number into a month name, you can put the number in a date as the month using the Date …

You can easily convert a date into the week number in Excel with the WeekNum Function. On the other hand, you can also calculate the days in the week …

When working on the dates, you may often use quarters in the reports. There are 4 quarters in a year and each spans 3 months. For example, the 3 …

The fiscal year is commonly used in the government for accounting and budget purpose. The start date varies from countries, e.g., some countries start in April while some countries …

When working with data extracted from the data server, you have a large chance to get the date in the "YYYYMMDD" text format. To convert the "YYYYMMDD" text string …

Dates in Excel are stored as serial numbers which can be switched from one format to another. There are many different ways to display a date. To convert a …