ExcelBanter - Exel 2002/2007-Always get 31 Oct 06

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Exel 2002/2007-Always get 31 Oct 06 (https://www.excelbanter.com/excel-discussion-misc-queries/119322-exel-2002-2007-always-get-31-oct-06-a.html)

[email protected]

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.

David Biddulph

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.

All times are GMT +1. The time now is 03:01 AM.