Excel: How to Subtract Dates From Today's Date
https://www.keynotesupport.com/excel-basics/date-how-to-subtract-dates-fron-todays-date-in-excel.shtml
The formula in C4, =TODAY()-B4, tells Excel to subtract the date in cell B4 from today's date, which is April 6, 2020. This is a classic use of Microsoft's TODAY function. If the sheet will never have missing dates, then this formula works! But if dates may be missing, your sheet will look unprofessional. Let's look at that problem and solution.
DA: 33 PA: 59 MOZ Rank: 5