How can calculate days between twodates
Solved/Closed
samruddhi naik
Posts
1
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 4, 2013
-
Feb 4, 2013 at 12:27 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Feb 6, 2013 at 10:11 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Feb 6, 2013 at 10:11 AM
Related:
- How can calculate days between twodates
- Skype last seen days ago - Guide
- How to calculate 90 days from date in excel - Guide
- You have 179 days left to request a review ✓ - Facebook Forum
- This account will be disabled in 1 day Are you sure that you want to log out? Y - Facebook Forum
- Move files older than x days windows - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 4, 2013 at 08:39 PM
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
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Feb 6, 2013 at 10:11 AM
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