Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

Hi,

I'd go with this addin

http://www.j-walk.com/ss/excel/files/xdate.htm

Mike

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

Thanks Mike for your response, that assumes there is not other way to do it.
I'm concern about an addin I installed once(not related to date) that even
when I turn it off
keeps giving me message that "the workbook has an add in..." everytime I
open the workbook, but hey, chances are risky and thanks again.
Thank you also FST1.

"FSt1" wrote:

jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

I share you concerns about addins of dubious origing but something produced
by John Walkenbach comes with a pretty impressive pedigree so I don't think
you need worry about this one.

Mike

"Excelfan" wrote:

Thanks Mike for your response, that assumes there is not other way to do it.
I'm concern about an addin I installed once(not related to date) that even
when I turn it off
keeps giving me message that "the workbook has an add in..." everytime I
open the workbook, but hey, chances are risky and thanks again.
Thank you also FST1.

"FSt1" wrote:

jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

Thanks a lot for the reassurance Mike. Now that I have you in line, do you or
anyone know if this date problem is overcome in XL 2007?
THANKS.
"Mike H" wrote:

I share you concerns about addins of dubious origing but something produced
by John Walkenbach comes with a pretty impressive pedigree so I don't think
you need worry about this one.

Mike

"Excelfan" wrote:

Thanks Mike for your response, that assumes there is not other way to do it.
I'm concern about an addin I installed once(not related to date) that even
when I turn it off
keeps giving me message that "the workbook has an add in..." everytime I
open the workbook, but hey, chances are risky and thanks again.
Thank you also FST1.

"FSt1" wrote:

jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

Hi,

No sorry and judging by some of the moans about 2007 it'll be some time
before I upgrade and find out.

Mike

"Excelfan" wrote:

Thanks a lot for the reassurance Mike. Now that I have you in line, do you or
anyone know if this date problem is overcome in XL 2007?
THANKS.
"Mike H" wrote:

I share you concerns about addins of dubious origing but something produced
by John Walkenbach comes with a pretty impressive pedigree so I don't think
you need worry about this one.

Mike

"Excelfan" wrote:

Thanks Mike for your response, that assumes there is not other way to do it.
I'm concern about an addin I installed once(not related to date) that even
when I turn it off
keeps giving me message that "the workbook has an add in..." everytime I
open the workbook, but hey, chances are risky and thanks again.
Thank you also FST1.

"FSt1" wrote:

jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

hi
i don't have 2007 and for the same reasons as mike but i do know that 2007
uses the same 1900/1904 date keeping system used by previouse xl versions so
i would guess that the pre-1900 date problem has not be addressed yet. I have
not seen all of the new functions yet and perhaps may not until i have 07 but
thats the way it goes.

Regards
FSt1

"Excelfan" wrote:

Thanks a lot for the reassurance Mike. Now that I have you in line, do you or
anyone know if this date problem is overcome in XL 2007?
THANKS.
"Mike H" wrote:

I share you concerns about addins of dubious origing but something produced
by John Walkenbach comes with a pretty impressive pedigree so I don't think
you need worry about this one.

Mike

"Excelfan" wrote:

Thanks Mike for your response, that assumes there is not other way to do it.
I'm concern about an addin I installed once(not related to date) that even
when I turn it off
keeps giving me message that "the workbook has an add in..." everytime I
open the workbook, but hey, chances are risky and thanks again.
Thank you also FST1.

"FSt1" wrote:

jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.

On Sun, 25 Jan 2009 13:55:02 -0800, Excelfan
wrote:

Thanks a lot for the reassurance Mike. Now that I have you in line, do you or
anyone know if this date problem is overcome in XL 2007?
THANKS.

This information is available looking at HELP for Specifications:

Earliest date allowed for calculation January 1, 1900
(January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation December 31, 9999
--ron