Date formula...help with return on formula
I got the formula from my previous post but now think something is wrong
with XL, here is what I am doing in cells A1 30 A2 6 A1 2005 Formula in A4 =DATE(A1,A2,A3)-10 Cell set to custom dd mm yy A4 returns 16/11/35 ( I reckon it should be 20/06/05) If I enter 25 5 2005 it returns 16/10/30 ( I reckon this should be 15/05/05) I have noticed A1 (dd) changes the YY in the return? Also and I can`t find it again but something that said excel for years up to 1999 Do I have an outdated version of excel? Juco |
If A1 houses a day number, A2 a month number, and A3 a year...
=DATE(A3,A2,A1)-10 would calculate as intended. Juco wrote: I got the formula from my previous post but now think something is wrong with XL, here is what I am doing in cells A1 30 A2 6 A1 2005 Formula in A4 =DATE(A1,A2,A3)-10 Cell set to custom dd mm yy A4 returns 16/11/35 ( I reckon it should be 20/06/05) If I enter 25 5 2005 it returns 16/10/30 ( I reckon this should be 15/05/05) I have noticed A1 (dd) changes the YY in the return? Also and I can`t find it again but something that said excel for years up to 1999 Do I have an outdated version of excel? Juco |
Ok thanks for being patient with me on the 2 posts, It is now sorted.
thanks much appreciated Juco "Aladin Akyurek" wrote in message ... If A1 houses a day number, A2 a month number, and A3 a year... =DATE(A3,A2,A1)-10 would calculate as intended. Juco wrote: I got the formula from my previous post but now think something is wrong with XL, here is what I am doing in cells A1 30 A2 6 A1 2005 Formula in A4 =DATE(A1,A2,A3)-10 Cell set to custom dd mm yy A4 returns 16/11/35 ( I reckon it should be 20/06/05) If I enter 25 5 2005 it returns 16/10/30 ( I reckon this should be 15/05/05) I have noticed A1 (dd) changes the YY in the return? Also and I can`t find it again but something that said excel for years up to 1999 Do I have an outdated version of excel? Juco |
All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com