View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default conditional formula: time to expiration date becomes < 6 months

Hi,
Try Cell Value, Less Than, =TODAY()+180

Regards - Dave.

"Susan" wrote:

How do I structure a conditional format when the time between today and an
expiration date is less than or equal to 6 months (180 days)?