How can calculate days between twodates
Solved/Closed
samruddhi naik
Kevin@Radstock
- Posts
- 1
- Registration date
- Monday February 4, 2013
- Status
- Member
- Last seen
- February 4, 2013
Kevin@Radstock
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
Related:
- How can calculate days between twodates
- Excel formula to calculate 90 days from a specific date - Guide
- Days calculator app download - Download
- Calculate no of days left from today to a future specified date ✓ - Forum - Excel
- How to calculate number of calender days ✓ - Forum - Programming
- How to calculate per day salary in excel - Forum - Excel
2 replies
venkat1926
Feb 4, 2013 at 08:39 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Feb 4, 2013 at 08:39 PM
if the dates ae entered as excel dates then I suppose
=A2-A1
will give what you want as 9
=A2-A1
will give what you want as 9
Kevin@Radstock
Feb 6, 2013 at 10:11 AM
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
Feb 6, 2013 at 10:11 AM
Hi
Assuming Start date: A1. End date B1.
1/ =B1-A1 =9
2/ =NETWORKDAYS(A1,B1) = 6
3/ =NETWORKDAYS(A1,B1,{"25/12/2012","26/12/2012"}) = 4
Those are a few ways, perhaps a bit more info.
Kevin
Assuming Start date: A1. End date B1.
1/ =B1-A1 =9
2/ =NETWORKDAYS(A1,B1) = 6
3/ =NETWORKDAYS(A1,B1,{"25/12/2012","26/12/2012"}) = 4
Those are a few ways, perhaps a bit more info.
Kevin