Hi, Fascinating! I get the same results as with a date-subtract app that I d/l'd a while ago, as I had decided to have a fiesta to celebrate half my life in Belgium. I wanted to be sure of the date, & no longer had that nice Casio calculator to do all the maths. As it turned out, it was May 19th 2004 (Excel & app agreed), which by a huge coincidence (in other circumstances) would have been my 31st wedding anniversary!
Regards, Richard.be ----- Original Message ----- From: "Rick Cogan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, June 27, 2005 5:29 AM Subject: Re: Excel Question // Subtracting Dates > ----- Original Message ----- > From: "Roger Helbig" <[EMAIL PROTECTED]> > Sent: Sunday, June 26, 2005 22:21 > > > > I am trying to subtract dates written in following format on an existing > > spreadsheet .. I have added another column > to make the subtraction, but > > results are grossly inaccurate because the subtraction includes the year <snip> > > The 2 date columns need to defined as a Date format and the result would > then be in number of days. > > Regards, > ************************************* > Rick Cogan from Melbourne, FL > [EMAIL PROTECTED] -- ---------------------------------------- The WIN-HOME list is hosted on a Windows 2000(TM) machine running L-Soft international's LISTSERV(R) software. To unsubscribe, write to [EMAIL PROTECTED] If you have questions about the list, write to [EMAIL PROTECTED]
