![]() ![]() ![]() ![]() So this is a simple formula method you can use to add months or years to a date in Excel. This way, we can use the EDATE formula to also make the function to add/subtract years from a date. This formula tells Excel to subtract the date in cell B4 from todays date, which is Apin our example. Substitute your cell reference for cell B4. For example, if you want to know the date after 1.5 years, you can do that (as 1.5*12 is 18, which is an integer). Enter the formula in C4, TODAY ()-B4, in the first cell. WORKDAY (B5,-7,F5:F12) GENERIC FORMULA WORKDAY (date,-workdays,holidays) ARGUMENTS date: A date that you want to subtract workdays from. As you can see, the parameter months is 12 (1 year * 12 months).Īlso, since we are multiplying the month’s value with 12, you can also use decimal numbers as years and it should still work in most cases. To enter the current date and time as a static value, simply press CTRL + (semicolon), enter a space and press CTRL + SHIFT + (semicolon). Note: this time will not change when you make a change to a cell or when you open the workbook. The result in C2 is May 31, 2022, which is 1 year after May 31, 2021. To enter the current time as a static value, press CTRL + SHIFT + (semicolon). ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |