View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Tan Man The Tan Man is offline
external usenet poster
 
Posts: 2
Default How to calculate next WORKDAY?

I need help with an IF statement/function for an Excel spreadsheet.
Here is what I am trying to do:

If I have a date in a cell and it happens to be Saturday or Sunday, I
want the IF statemnt to give the next WORKDAY.

For example:
12//3/2005 Saturday
The functin should look at this date, determne that is A WEEKEND date,
then provide the next WORKDAY 12/05/2005 Monday.

Any suggestions?

The Tan Man