All resources related to DATE AND TIME for Excel and Google Sheets.

Next biweekly payday from date

Figure 1. Next Biweekly Payday from Date. Let's say we seek to determine the next payday in a biweekly payday schedule - with Friday as the assumed payday- we are going to make use of a formula which is obtained from the Excel CEILING function. Generic Formula =CEILING(date+1,14)-1 The first...

How to Calculate the Next Anniversary Date in Excel

Figure 1. Next Anniversary Date in Excel. We are going to make use of a combination of the Excel EDATE and DATEDIF functions in order to determine the next anniversary date between a specified start and end date in days, months, or years. Generic Formula =EDATE(date,(DATEDIF(date,as_of,"y")+1)*12) date is the specified date...

How to Check if a Year is a Leap Year in Excel

Figure 1. Year is a Leap Year in Excel. We are going to use a formula that consists of the Excel MONTH, YEAR, and DATE functions in order to ascertain whether the year of a given date is a leap year, Generic Formula =MONTH(DATE(YEAR(date),2,29))=2 In the formula above, February has...

Display the current date and time

Figure 1. Display the Current Date and Time in Excel. We can make use of the Excel NOW Function to display the current date and time in our worksheet. Generic Formula =NOW() Whenever our worksheet is opened or recalculated, the date and time will update automatically. How to use the...

Get first day of previous month

Figure 1. Get First Day of Previous Month in Excel. If we are required to get the first day of a previous month in Excel, we are going to utilize the EOMONTH function. Generic Formula =EOMONTH(date,-2)+1 The EOMONTH function operates by calculating the amount of days and months that it...

Get first Monday before any date

Figure 1. Get First Monday Before Any Date in Excel. Let's assume that we are required to find the first Monday occurring before a specific date in Excel, we will have to make use of the WEEKDAY function. Generic Formula =date- WEEKDAY (date - 2) The WEEKDAY formula will help...

Next business day 6 months in future

Figure 1. Next Business Day 6 Months In Future Excel.. Let us assume that we have to determine a specific date, 6 Months In advance, which must also occur on a working day, we have to use a combination of the Excel WORKDAY and EDATE Functions. Formula Syntax =WORKDAY(EDATE(date,6)-1,1,holidays) The...

Next working day

Figure 1. Next Working Day in Excel. If we are required to determine the next day if work or business, based on a specific date, we can achieve this by utilizing the Excel WORKDAY Function. Generic Formula =WORKDAY(date,1,holidays) date is the specific date from which we want to start counting....

How to Use the Excel DATE Function

Figure 1. Excel Date Function. If we have to assemble dates that require dynamic changes based on other values in our worksheet, we are going utilize the Excel DATE Function. Formula Syntax =DATE (year, month, day) day = Number value of the day month = Number value of the month...

Sum race time splits

Figure 1. Sum Race Time Splits in Excel. Let us assume that we are required to sum up different race time splits that are the results of races between several competitors, we are going to use the Excel SUM function to achieve this. Generic Formula =SUM(range) The Excel SUM function...