Previous Topic Next Topic

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
Hello,

I HVE TO CALCULATE THE DIFFRENCE IN DATE.
e.g: there is a two coloums as per below,

purchase requisition date purchase order date Days require to convert PR to PO
22/12/2012 31/12/2012 (how many days required to convert
PR in PO) diff

Thanks in advance

2 replies

Answer 1 / 2
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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
0
Answer 2 / 2
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
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
0