Thread: Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David G David G is offline
external usenet poster
 
Posts: 3
Default Date

I have a series of dates in column f, and the formula is
DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)), but I need to check if this date is a
weekend or weekday. Let us say 06/18/05 is a saturday, I need that cell to
display 06/20/05, is that possible. Any help you can provide would be
greatly appreciated.

Thanks in advance