Thread: Date format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
john john is offline
external usenet poster
 
Posts: 97
Default Date format

I would think you could calculate the difference by
adjusting the two dates to be the same day of the week
(via the weekday function), calculating the difference and
dividing by 7 to get the # of weekends, subtracting 2*
that from the difference, and then adding back what your
adjustment was.

John


-----Original Message-----
I need to be able to insert a date into one row and then
link it to anothr row only I need it to be able to use
calender days so that I can not count work days i.e.
weekends for scheduling purposes. Please help or tell me
it can't be done. Thanks a million.
.