![]() |
|
#8
|
|||
|
|||
|
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! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Style for Text Changes from Normal to Heading 1 when Copy-Pasted | Basia | Word | 8 | 08-15-2015 02:32 PM |
Prevent access to raw data in a pivot table?
|
Chancy | Excel | 3 | 02-03-2015 11:33 AM |
Conditional Formatting over copied and pasted data
|
kb3264 | Excel | 6 | 07-11-2012 07:12 AM |
Stop underlining pasted data
|
LarryStroup | PowerPoint | 5 | 01-11-2012 12:47 PM |
Numbered list turns to bullets when copy/pasted
|
cathleenmcguire | PowerPoint | 6 | 08-31-2011 08:07 AM |