Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula/macro help
In Column "T" I have in text format dates in the following format dd mmm
yyyy. Reason for text format, I sometimes do not have the year. Is it possible to write a formula in column "V" that if row "XX" and column "T" are not blank and number of characters are greater than six, the right four numbers are subtracted from the current year, providing a number of years value. Or would this require a macro? -- Regards Michael Koerner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Formula for Max value | Excel Worksheet Functions | |||
Macro Formula for Max value | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Using the And formula in a VBA macro | Excel Programming | |||
how to add formula to this macro??? | Excel Programming |