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
|