View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
just_jon
 
Posts: n/a
Default Date the input, then tell if over 7th off month

Change C5 to: =IF(LEN(D5),TODAY(),"")

and copy to C6.