DATE AND TIME Articles: Excel and Google Sheets

We can count day of week between dates in Microsoft Excel. Doing it manually can be very frustrating. We can extract the results automatically. The functions used to count days of week between dates are - ROW, WEEKEND, INDIRECT and SUMPRODUCT. In this tutorial, we will learn how to count...

Many companies have a policy that states employees have to retire after a certain age. We can calculate this retirement date from the birth date. To do this, we need to use the EDATE and YEARFRAC functions in Excel. In this tutorial, we will learn how to calculate retirement date...

The WEEKNUM function in Excel is one of the major functions used by financial analysts. It helps us to find out the week number from a given date. This function tells us which week number (1-54) in the year a date belongs to. While working on financial statements, it is...

It may seem that analyzing dates while excluding weekends would be a challenging calculation. However, with specialized functions, WORKDAY and WORKDAY.INTL, Excel has made it easy to add or subtract workdays without weekends and holidays (optionally) to a given date value. This article will step through the process. Figure 1....

To effectively manage projects or activities we encounter a situation we need to determine how many days of project 1 fall into project 2. Using the same approach, we can also calculate how many days of a project date range (start date and end date) overlap with a specific date...

While planning activities and scheduling an event we often need to look for the date of a specific last weekday of the month in the calendar. In Excel, we can get the end of the month date for a given date using the EOMONTH function, and find the day of...

When we have a targeted deadline to meet or an expiration date is given then we may need to calculate the days remaining until deadline date or expiration date from today. In some cases, we have two dates and we need to calculate the days remaining between these two dates....

We often compare two dates and calculate the difference between them in terms of days, weeks, months and years. In Excel, we can calculate years between dates using specialized functions like YEARFRAC and DATEDIF functions. This step by step tutorial will help all levels of Excel users calculate the number...

In Excel, when we need to calculate business days or workdays between two dates, excluding weekends and holidays, we can use the NETWORKDAYS and NETWORKDAYS.INTL functions. But with the NETWORKDAYS.INTL function we have additional choice to use the custom weekend parameter and set a custom weekday(s) as weekend(s). This article...

The Julian date format is generally used as a timestamp in programming, manufacturing or other related fields like a reference for a batch number. Generally, it has two format variations, comprising of 5 or 7 digits numbers, but in most of the cases, 5 digits format is used. Here, we...