Thread: Formula to Display Date n-Workdays from a Certain Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Formula to Display Date n-Workdays from a Certain Date
I am having trouble displaying a date 15 workdays from a specific
date. For example, if I have 6/1/2007 in cell A1, I would like to
display the date 15 working days from the date in A1. I can display
15 days from A1 but don't know how to get 15 working days from A1.

=WORKDAY(A1,15,<<holiday list if any)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Rick

Reply With QuoteReply With Quote