View Single Post
 
Old 05-10-2016, 01:24 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you're only interested in the year part, you could use:
=IF(LEN(A3)<5,A3,YEAR(A3))

In a situation where some data have only years and other data have months & years, that would seem to be the most consistent way of analysing them; otherwise you'd need to analyse the data with months & years separately from the data with years only, to avoid skewing the analysis.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote