For example, if you start a project on 01 Jan and it ends on 31 Jan, the DATEDIF function will give the number of months as 0 (as it doesn’t count the start date and according to it only 30 days in January have been covered) Also read: Calculating Time In Excel Using YEARFRAC Function (Get Total Months Between Two Dates)Īnother method to get the number of months between two specified dates is by using the YEARFRAC function. Note: DATEDIF function will exclude the start date when counting the month numbers. In case you want to get the total number of months as well as days between two dates, you can use the below formula: =DATEDIF(A2,B2,"M")&"M "&DATEDIF(A2,B2,"MD")&"D" So, if you’re using DATEDIF in Excel, you need to know the syntax. When you type the =DATEDIF in a cell in Excel, you would not see any IntelliSense or any guidance on what arguments it can take. DATEDIF is one of the few undocumented functions in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |