View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default date after another date

On Wed, 20 Aug 2008 21:17:19 +0100, "Bob Phillips"
wrote:

There is a problem with that approach Ron. If the 1st of Jan is say a
Saturday, your formula returns the Monday date. But that will be the New
Year's day holiday, so it should be skipped.


Well, there are places or businesses where that is the case. But not in the
businesses that I've been involved in.

And if so, then the OP should include those holiday dates.
--ron