Date difference
 

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

Date difference
 

Try:-

=NETWORKDAYS(N7,R7)

Mike

"Jock" wrote:

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

Date difference
 

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

Date difference
 

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