View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default Calculating a percentage of days in a term


Sounds like you need WORKDAY function, why didn't that work? To add 3
workdays to a date in A1

=WORKDAY(A1,3)

You need to have Analysis Toolpak installed for WORKDAY to work,
otherwise you'll get a #NAME? error.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=551061