If the month in B1 (which is 10) is greater than or equal to today's month, then subtract today's month from the month in B1. You could write the following formula, also using the IF function: =IF( MONTH(B1) >= MONTH(TODAY()), MONTH(B1) - MONTH(TODAY()), 12-(MONTH(TODAY())-MONTH(B1))) Say you wanted to know the number of months until the person's next birthday month. If we were to view the Excel workbook any time in 2020, then =YEAR(TODAY()) would return 2020 and =YEAR(B1) would return 1992, so we would get a result of 28. This would return the number of years between the date in B1 and today's date. You could write the following formula: =YEAR(TODAY())-YEAR(B1) If someone's birth date was displayed in cell B1, then the following formula would return the person's age in days because it returns the number of days between today and the date in the cell: =TODAY()-B1īut say you wanted the person's age in full years. We can use the date components in Excel to find the difference between dates in days, months, and years. Finding the Difference Between Dates in Excel =MONTH(TODAY()) would return 3 (because March is the 3rd month from January to December) and =DAY(TODAY()) would return 12. =YEAR(TODAY()) will return the current year, =MONTH(TODAY()) will return the number of the current month (from 1 to 12), and =DAY(TODAY()) will return the current day of the month (from 1 to 31).įor example, if the date was March 12, 2021, then =YEAR(TODAY()) would return 2021. In Excel you can extract the day, month, and year components from a date. Finally, you will learn how to insert the current time and how to extract the time from timestamps containing the date and time.Getting Today's Month, Day, and Year in Excel Third, you will learn how to add and subtract hours, minutes, and seconds from a given time. Second, you will learn how to find the difference between two specific times. First, you will review the difference between the time and duration formats, which allow you to work with time units in different ways.

In this guide, you will learn different ways of adding and subtracting time in Google Sheets.

For example, you can calculate the difference between two clock times, add hours, days, and seconds to existing times, and get the time value of a specific time as a fraction of a day. Best of all, you can work with different types of data easily, using the same symbols and operators. Google Sheets is a flexible and easy-to-use spreadsheet program where you can do anything from basic arithmetic operations to complex data analysis.

Excel formula subtract from todays date