Thread: Date difference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jock Jock is offline
external usenet poster
 
Posts: 440
Default 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