View Single Post
 
Old 05-10-2016, 04:01 AM
BRDas BRDas is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2016
Posts: 4
BRDas is on a distinguished road
Default

Yes, good point, but then how to structure a single formula that will deal with both possibilities and give a meaningful result? ISTEXT will be false for both and ISNUMBER will be true for both. YEAR gives the correct result when applied to the Month and Year combination, but when applied to the single four digit year it treats it as a Julian date and gives "1905". The only thing I could come up with, since none of the dates will be from the early 20th century is the following:

=IF(YEAR(E3)>1950,TEXT(E3,"mmmm") & TEXT(E3,"yyyy"),E3)

That should do it!

Thanks for your help!
Reply With Quote