Thread: Comparing dates
View Single Post
  #1   Report Post  
Debbie F
 
Posts: n/a
Default Comparing dates

Hi

I have a date in A5 and I need to write a formula in an adjacent column that
checks the date and if the date is less than 3 months old to display it in
another colour, if it is more than 3 months old to do nothing.

I am not sure which date function to use. Can anyone help?

Thanks