Column D shows the formula that was actually used in column C to get the result shown in column C. The table below shows sample formulas using each of the unit options. There are 3 additional more unusual options that are explained in the example below. Unit meaning the unit of measure, can be “D”, “M”, or “Y” for day, months, or years respectively. Start date and end date are self explanatory. The format for the function is DATEDIF(start date,end date,unit). The explanation I heard for this is that it isn’t a standard Excel function, it is only included for backward compatibility with Lotus 1-2-3. You won’t find this one in the function wizard so you will have to remember how to type it in yourself. The best way is to use the DATEDIF() function. If you want to know the number of months or years between two dates, things get trickier. But all you have to do is set the formatting for that cell to General or to any number format (right-click > choose Formatting) to make the result show as 29. Excel may automatically format the cell with the formula in it as a date, which means instead of seeing 29, you’ll see. For example if cell A2 has an invoice date in it of and cell B2 has a date paid of, then you could enter use the formula =B2-A2 to get the number of days between the two dates, or 29. If need to know the number of days between two dates, that is very easy to do in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |