How Do You Make Excel Automatically Count Days From A Specific Date?

How Do You Make Excel Automatically Count Days From A Specific Date? Calculating the number of days using Excel is pretty simple. Just use a formula to subtract the later date from the earlier date. For example, if cell A1 contains 1-Jan-2004 and cell A2 contains 03-Mar-2004, you simply enter the formula =A2-A1 in cell