Date Help

need to write a formula where it interprets a "date" such as 01/28/14 and brings back in this case "201401" as the result.  Meaning I want the year than the month.

Thanks
Pete EdwardsAsked:
Who is Participating?
 
Santosh GuptaConnect With a Mentor Commented:
Hi,

Try assuming date in A1.

=TEXT(A1,"yyyymm")
0
 
Pete EdwardsAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.