View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pluribus Pluribus is offline
external usenet poster
 
Posts: 2
Default Conditional Date formula

Hi

I need to create a formula which takes the date in cell A1, adds 358 days,
and if the result is todays date or later return a value of Yes in a coloured
cell, otherwise return a value of No in a plain cell.

My Date format is DD/MM/YYYY.

Thanks for your help in advance!