Date merge

M

Mary C

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.
 
J

JLatham

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.
 
Top