*Walter Hildebrandt* typed up the following, at 21-Nov-07 13:37 (UTC+1100) ;

Thank you for the three helpful answers to my "Copy A Formula" question.

On a spreadsheet there are two dates.  Is there a way to calculate the number 
of days between the two dates.  For example if one cell had a date of January 
1, 2005 and another cell had a date of May 10, 2007, is there a way to 
calculate the number of days between the two dates?

Cell A1 has first date.
Cell A2 has second date.
Cell B1 formula is "A2-A1".

You may need to format Cell B1 to display number rather than date format.

--
Klaas Visser
Sydney, Australia

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to