Date difference

[Jock]

Hi,
The following code will return the difference between the dates in N7 and R7:
=IF(R7="","",DAYS360(N7,R7,TRUE))
It doesn't take into consideration weekends.
Can this formula be changed to ignore weekends?

 

[Mike H]

Try:-

=NETWORKDAYS(N7,R7)

Mike

 

[Niek Otten]

Hi Jock,

Look at the NETWORKDAYS() function.
If you get a #NAME Error: Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
| The following code will return the difference between the dates in N7 and R7:
| =IF(R7="","",DAYS360(N7,R7,TRUE))
| It doesn't take into consideration weekends.
| Can this formula be changed to ignore weekends?
| --
| tia
|
| Jock

 

[Jock]

Thanks Niek & Mike H.
Sorted.

Jock