Thanks Niek & Mike H.
Sorted.

Jock


"Niek Otten" wrote:

Hi Jock,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jock" wrote in message ...
| 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