Date merge

G

Guest

I have the year (2006) in cell A1 and the month (7) in cell B1 of a pivot
table. When extracting them from the pivot table is it possible to combine
them into one cell as a date? When I enter A1+B1 it returns 20067 instead of
the date. Thanks.
 
G

Guest

Try this formula:
=DATE(A1,B1,1)
The ,1) just says 1st day of the month. You can format the cell that
formula is in to get the date to be displayed the way you want it to be.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Change to US Date Format - Why? 2
Convert Date in Excel from mm/dd/yy to yyyymm 3
How to change the year digit? 4
Date converts to number when part of a formula 3
Refreshing Pivot Table on a protected spreadsheet tab 1
Sumproduct Date Format Question 6
Help to create a macro 2
Auto Forward in Mailbox 4

Top