DATE AND TIME Articles: Excel and Google Sheets

Excel allows us to easily combine date and time through the use of simple arithmetic operations and some formatting adjustments.  This article provides a step-by-step tutorial on how to add date and time.   Figure 1.  Final result:  How to add date and time Date and time Date has a...

Excel offers some very important functions for date and times. To get the current date and time we can use the NOW and TODAY functions. In this tutorial, we will learn how to insert current date and time in Excel. Figure 1. Current Date and Time in Excel How to...

How do you tell if dates share the same month a year in excel? You can test is Date is same month and year very easily by applying the MONTH and YEAR functions. The functions make a perfect formula for this kind of problem. Check out how the formula looks like:...

In this tutorial, you will learn how to get project start date when we have start day and project duration in workdays. This is possible by using Excel WORKDAY function. This function returns a date in a specific range (before or after selected date). In our case, it will return...

In this tutorial, you will learn how to get project midpoint when we have start day and project duration in workdays. This is possible by using Excel WORKDAY function. This function returns a date in a specific range (before or after selected date). In our case, it will return a...

In this tutorial, you will learn how to get project end date when we have start day and project duration in workdays. This is possible by using Excel WORKDAY function. This function returns a date in a specific range (before or after selected date). In our case, it will return...

In this tutorial, you will learn how to get percent of year complete for a date. This is possible by using a combination of Excel functions YEAR, DATE and YEARFRAC. YEAR function returns a year for a date. DATE function returns a date for a day, month and year. YEARFRAC...

In this tutorial, you will learn how to get quarter from date in Excel. To be able to calculate a quarter, you will have to get familiar with MONTH and ROUNDUP functions. The MONTH function returns a month from a date, while ROUNDUP function rounds a ratio. Get quarter from...

WORKDAY.INTL function returns a date that is before or after a provided number of workdays. The function allows specifying which days of the week are weekends and excluding specified holidays.    Excel WORKDAY.INTL function Generic Formula =WORKDAY.INTL(start_date,workdays,[weekend],[holidays]) weekday is an optional argument. It indicates which weekdays are weekend days. This...

Counting dates in the current month are crucial especially if you are running a project with a predetermined time frame. However, counting manually can be tiresome and not to mention possible errors. But you can avoid all these hustles by using COUNTIFS OR SUMPRODUCT function. How To Count Dates In...