DATE ==> No of Days of the year till date

DATE ==> No of Days of the year till date

This example make you learn how to count number of date from given date in Excel.  If you want to be live demo, download the Excel file.

 

Date Total Days From 1st Jan to Given Date
2/14/2017 45

 A2-DATE(YEAR(A2),1,1)+1

 

 

Share this post

Post Comment

6 + 9 =