Date

[Wayne1.1]

How do I calculate the difference between two dates (each in separate cells) in working days?

 

[VoG]

Try

=NETWORKDAYS(A1,B1)

where A1 holds the earlier date.

In Excel 2003 and earlier you will need the Analysis Toolpak from Tools > Add-Ins.

 

[CWatts]

Try the =NETWORKDAYS formula.

 

[Wayne1.1]

Thanks, but this just shows #NAME? in formula cell.

 

[VoG]

Please note:

In Excel 2003 and earlier you will need the Analysis Toolpak from Tools > Add-Ins.

 

[Wayne1.1]

Got the =NETWORKDAYS function to work on our network. How do you calculate calendar days? I have researched =DAYS360, but as an example - if I get a report on 4/8/11 and complete on 5/8/11, to me this has taken 2 calendar days, but =DAYS£60 says it is 1 calendar day! Can you suggest a formula that counts the day of receipt?

 

[VoG]

Try this

Excel Workbook
	A	B	C
1	04/08/2011	05/08/2011	2
Sheet1

 

[Wayne1.1]

Hi, Thanks, but =NETWORKDAYS formula is only showing working days. I now want a formula to count the day report is received and weekends too. For example 6/1/2011 to 13/1/2011 is 8 days. =NETWORKDAYS formula reads this as 6 days, whilst =DAYS360 says this is 7 days. What formula do I use for reaching the 8 days in this example? Thanks for for help.

 

[VoG]

Simply subtract the earlier date from the later date and add 1

Excel Workbook
	A	B	C
1	06/01/2011	13/01/2011	8
Sheet1

 

[Wayne1.1]

Thanks, this worked a treat.