If you switch the dates in the formula, you’ll just get a negative number. This function takes two arguments: the end date and the start date. In addition, you can also use the DAYS function. Excel knows it’s a date and simply calculates the number of days between those two dates. The first formula is just a simple subtraction of the two dates, A3 – A2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |