Date merge
 

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.
--
Mary C

Date merge
 

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.

"Mary C" wrote:

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.
--
Mary C

Date merge
 

=date(a1,b1,1)
will give the 1st day of that month.



Mary C wrote:

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.
--
Mary C

--

Dave Peterson

Date merge
 

Perfect - Thanks to both of you
--
Mary C


"Dave Peterson" wrote:

=date(a1,b1,1)
will give the 1st day of that month.



Mary C wrote:

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.
--
Mary C

--

Dave Peterson