Donate SIGN UP

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
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.
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
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

1 to 2 of 2rss feed

Do you know the answer?

Date calc

Answer Question >>