View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jjhacke jjhacke is offline
external usenet poster
 
Posts: 1
Default how do i create a formula to give a workday date?

I am trying to set up a worksheet the gives me a date during the work week
that is 5 work days, 10 workdays, etc from the date that is entered.

I also want the cells to result in TBD until the first date is input.

Here is an example of the formula I created that gives me TBD but not a
workday date.

=IF(H280,H28+14,"TBD")