View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Conditional Formatting - workdays only

Hi all, hope you can help. Excel 2003

I need to use conditional formatting on a cell if the date in this cell is
14 working days Today(). I'm not sure where to place the (AI1-Workday)
part within the formula bar

=TODAY()-$AI$814
--
Regards
Mike