Donate SIGN UP
Home > Technology > Computers > Date calc

Date calc

Avatar Image
keithg | 07:27 Mon 20th Sep 2010 | Computers
2 Answers
In Lotus 123 and Excel 2007 (I use both) is it possible to put a formula into a cell to calculate the number of days between two dates?
Thanks
keithg
prev Answerbank
  
next Child Lock
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by keithg. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image ChuckFickens
don't use lotus, so don't know, but in excel

=DATEDIF(A1,A2,"d")

Would tell you the number of days between dates in a1 and a2

http://spreadsheets.a...ays_between_dates.htm
07:35 Mon 20th Sep 2010
Avatar Image keithg
Question Author
Thanks ChuckFickens for your quick and correct answer, the spreadsheet was in 123 but I have converted it to Excel, now does exactly what I want.
Thanks
keithg
08:27 Mon 20th Sep 2010

1 to 2 of 2rss feed

Do you know the answer?

Date calc

Answer Question >>