View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joeyej Joeyej is offline
external usenet poster
 
Posts: 2
Default Comparing old date to now() and writing out text message in column

I'm new to Excel programming & I'm working on a [stock purchase]
spreadsheet trying to compare a column of dates (range named
"acquired") to the current date. Any acquired date over 365 days
should write a text message saying "long" in the adjacent column range
named "holding". Acquired dates less that 365 needs to write "short".

Thanks for your help.

Joe