View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christine Christine is offline
external usenet poster
 
Posts: 147
Default Workdays function not working

My formula doesn't produce an error, but it doesn't work either! Can someone
help?

DateFrom is the name I've applied to cell N9.

In cell G23 I want to show DateForm - 7 working days, so I've entered this
formula in the cell:
=IF(DateFrom<"",WORKDAY(DateFrom,-7),"")

Can someome tell me what's is wrong with this syntax? (Analysis Toolpack is
installed.)

Many thanks!