| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in middle of month | Excel Discussion (Misc queries) | |||
| Merge date | Excel Discussion (Misc queries) | |||
| Using a date field in mail merge | Excel Discussion (Misc queries) | |||
| How to filter on a date field during mail merge | Excel Worksheet Functions | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Hybrid Mode
