| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exel 2002/2007-Always get 31 Oct 06
I am using a formula of:
=DATE (YEAR(TODAY()), MONTH(TODAY()), A1) A number (day of the month) is in Column A and this formula is in Column B. Inserting just a number in Column A will show the date in Column B. i.e. 2 Nov 06 But, doing this in an older Wks will show the date as ONLY 31 Oct 06. I have tried a bunch. A new WKS will be correct in the date. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Exel 2002/2007-Always get 31 Oct 06
Are you sure you've got the calculation mode set to Automatic?
-- David Biddulph wrote in message ups.com... I am using a formula of: =DATE (YEAR(TODAY()), MONTH(TODAY()), A1) A number (day of the month) is in Column A and this formula is in Column B. Inserting just a number in Column A will show the date in Column B. i.e. 2 Nov 06 But, doing this in an older Wks will show the date as ONLY 31 Oct 06. I have tried a bunch. A new WKS will be correct in the date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change formula into value exel cells | Excel Worksheet Functions | |||
| how 2 convert (exel macro's mysql) ?? | Excel Discussion (Misc queries) | |||
| how do I convert a non exel tabulation to exel | New Users to Excel | |||
| tidslinje i exel | Charts and Charting in Excel | |||
| Need help with exel database | Excel Discussion (Misc queries) | |||
Linear Mode
