View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Syntax-evaluate (enddate - duration = startdate)

Maybe using =workday() from the Analysis toolpak (in xl2003 and below) would do
what you want.

See Excel's help for more information.

JeannetteH wrote:

I need a formula that will provide a workday date if the duration in days is
subtracted from a given end date. I found variations of what I need on the
internet, but I do not know how to pull it together. Attempts have failed.


--

Dave Peterson