The formula calculates and round the number of months down, if you want to get the nearest whole month, you can use the formula as this: DATEDIF(start_date,end_date+15,"M") Press Enter key and drag fill handle over the cells that need this formula.ĭATEDIFfunction: returns the number of complete years, months or days between dates. To count the number of months between dates in cell B3 and C3, please use below formula: =DATEDIF(B3,C3,"M") The formula returns a whole numeric value that indicates the number of months.ġ While the start_date is greater than the end_date, the formula returns an error value #NUM!Ģ While the start_date or end_date is not valid dates (a text value or not a valid date in Excel such as dates before ), the formula returns an error value #VALUE! Syntaxt and Arguments Start_date, end_date: the two dates that you want to get months difference between. Generic formula: DATEDIF(start_date,end_date,”M”)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |