amit arun associates
   
Home Contact Us Site Map
Home about us Latest News Contact us

Fixed Assets Verification Services

Payroll Processing Service

Employee Benefit Administration

Tax Consulting

Foreign Direct Investment

File GST & E-TDS Returns
 
 
 
 
 

Excel - Calculate No of Days between two dates

Posted @ May 26, 2015, 11:15 pm under (Valuation Services)

= DATEDIF ( start_date , end_date , unit )
 
The function has three arguments that need to be entered as part of the function:
 
start_date - the first or starting date.
end_date - the second or last date.
unit - tells the function to find the number of days ("D"), complete months ("M"), or complete years ("Y") between the two dates.
The unit argument can also be a combination of days, months, and years:
 
"YM" - excludes years - calculates the number of months between two dates as if the dates were in the same year.
"YD" - excludes years - calculates the number of days between two dates as if the dates were in the same year.
"MD" - excludes months - calculates the number of days between two dates as if the dates were in the same month and year.

Website Designing  Company Image Map
Contact us Disclaimer Privacy Policy Site Map