Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well my issue not to upgrade and find out myself is the same wordwide and
most popular issue of all of us:money( cost around 150.00). However if you get the opportunity to upgrade and find out for yourself then do it and don't let no one decide for you if is good or bad. This advice comes from a person that everyone told " Vista is a piece of ..." , got a new computer with VISTA and found out that in reality Vista is a piece of ... not the best example, but the moral is that I find out by myself. New things are different but usually improved and most people dont like them. Worst of Vista is the compatibility problem. However whenever I get the chance(and the money), for sure I'll buy XL 2007 and post back. Thanks Mike for your time and help. "Mike H" wrote: 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. |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |