To subtract a date from today's date: =TODAY()-DATE(2015,5,20)The formula calculates how many days are between the current date and some other date that you specify.

And here are a few more examples where Excel DATE is used in combination with other functions in more complex formulas: And this formula outputs a serial number for the first day of the current month in the current year: Find the first day of month - how to get the 1st day of the month by the month number, from a given date and based on today's date. Subtracting days from a date: =DATE(2015, 5, 20) - 15The result of the above formula is May 5, 2015, which is May 20, 2015 minus 15 days.Get the day of the year in Excel - this example explains a DATE/YEAR formula to get a day's number. The templates are saved in Microsoft Excel ".xlsx" format and can be used with the newer versions of Excel that support the XML document standard (Excel 2007, 2010, 2013, 2016, 2019, 2021 and Office 365). If you have one of the older versions of Excel that only supports the ".xls" format (Excel 2000, 2002/XP & 2003), or if you don't have Excel installed, use Microsoft Office Online or one of the Microsoft Excel/Microsoft Office alternatives FreeOffice PlanMaker, LibreOffice Calc, Google Sheets and others, which are all free of charge ( OpenOffice Calc unfortunately has minor formatting problems when opening our calendars). Also compatible with Microsoft Office for Mac (macOS) and Microsoft Office mobile for iPad/iOS, Android and Windows 10 mobile. Excel interprets the year argument according to the date system set up on your computer. By default, Microsoft Excel for Windows uses the 1900 system where January 1, 1900 is represented by the serial number 1. For more details, please see Excel date format. Below you will find a few examples of using DATE formulas in Excel beginning with the simplest ones. Example 1. DATE formula to return a serial number for a date

Tip. To display a date rather than a serial number, apply the desired Date format to the formula cell. Example 2. How to return a date based on values in other cells For example, to find the serial number for the date, taking the values in cells A2, A3 and A4 as the year, month and day arguments, respectively, the formula is:The DATE syntax looks crystal clear and straightforward on the surface. In practice, there may be some unobvious pitfalls that the below tips will help you avoid. Year The files are saved in Adobe PDF format (file extension .pdf) and can be opened with the Adobe Acrobat Reader and most other PDF readers, for example the PDF-XChange Viewer and the Foxit Reader. The files can be scaled up and down so they can be printed on paper sizes larger or smaller than standard letter paper (see instructions). In case you want not only to calculate but also highlight dates in your Excel worksheets, then create conditional formatting rules based on DATE formulas. The DATE function is very helpful for calculating dates where the year, month, and day values are stored in other cells. Calculate the number of days in a month - how to get the number of days based on the month number or on a date.