Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Date Help

Posted on 2014-04-10
2
Medium Priority
?
119 Views
Last Modified: 2014-05-12
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
0
Comment
Question by:Pete Edwards
2 Comments
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 2000 total points
ID: 39992158
Hi,

Try assuming date in A1.

=TEXT(A1,"yyyymm")
0
 

Author Comment

by:Pete Edwards
ID: 39992167
thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to find and create templates in Excel 2013.
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question