tywalker2276
New Member
- Joined
- Feb 2, 2012
- Messages
- 10
Hello all,
I am looking to write a formula that will display the end year of a date or simply list a "-" if anything other than a date is listed. For example, column E of my spreadsheet lists dates ie.. 06/01/13, 7/30/13 etc... but it also has empty cells as well as some text in the cells. In column Q, I would like to write the formula that would show what the corresponding year is in column E if a date is listed. If no date is listed or if there is text in that column, I would simply like a hyphen to be shown in column Q.
Any ideas?
Thanks everyone!
Tyler
I am looking to write a formula that will display the end year of a date or simply list a "-" if anything other than a date is listed. For example, column E of my spreadsheet lists dates ie.. 06/01/13, 7/30/13 etc... but it also has empty cells as well as some text in the cells. In column Q, I would like to write the formula that would show what the corresponding year is in column E if a date is listed. If no date is listed or if there is text in that column, I would simply like a hyphen to be shown in column Q.
Any ideas?
Thanks everyone!
Tyler