Returns the number of days between 2 dates as a year fraction.
Christmas bells are ringing. Time to say goodbye to 2016 and welcome 2017. Spending most of my time with MS Excel creating templates and other documents, today I decided to make Calendar 2017 in MS Excel. Click the link below to download the Calendar 2017 click on the link below: 2017 Calendar & Year […]
Let me show you how to convert the number of days to year/month/day in the prescribed format “1 year 4 months 25days” in Excel. Convert number of Days to year/month/day format For this, we need to use the DATEDIF function. Syntax for DATEDIF Function: DATEDIF(start_date,end_date,unit) First of all select a blank cell you where we […]