how can calculate days between twodatesSolved/Closed

Question

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

Configuration: Windows XP / Chrome 24.0.1312.56

venkat1926 · Answer

if the dates ae entered as excel dates then I suppose 
=A2-A1
will give what you want as 9

Kevin@Radstock · Answer

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

How can calculate days between twodates

2 responses

Similar discussions

Subscribe To Our Newsletter!