| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| writing text to different cell after comparing | Excel Worksheet Functions | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Warning message if one column contains any text and another column is blank | Excel Worksheet Functions | |||
| Date format/Writing to a file problem | Excel Discussion (Misc queries) | |||
| help with VBA code re comparing cells and generating message with detailed info | Excel Programming | |||
Threaded Mode
