Ubuntu
openoffice.org package

Calc Formula - Determining amount of time elapsed

Asked by Joel Montes de Oca

I would like to know if I can determine how much time has past between two dates. For example 8/01/07 is 6 days ago from today (8/07/07)

I want to be able to do the following:

In one cell I type in a date and on a different cell, I want Calc to tell me how long ago it has been (it would have to take into account my current date). I would like to put 8/01/07 into one cell and have 6 pop out on an other cell.

How can this be done?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Rodrigo Donado
Solved:
Last query:
Last reply:
Revision history for this message
Best Rodrigo Donado (frezeeer) said : 		#1

Hi:

have you tryed:
="8/01/07"-"08/07/07"

I'm not in front of my computer but I remember it being like that. Try setting the cell as number not as date.

Revision history for this message
Joel Montes de Oca (joelmontes01) said : 		#2

That works but it gives me a werid answer.

Example ="08/06/07"-"08/07/07" spits out 12/29/99
and if I flip it around so it reads ="08/07/07"-"08/06/07" it spits out 12/31/99

Revision history for this message
Cesare Tirabassi (norsetto) said : 		#3

Thats correct. To have the number of days you have to format your answer as number (not date).

Revision history for this message
Krzysiek (krzys-h) said : 		#4

Hi,
You can also use the built-in function named "DAYS" (Insert > Finction)

Revision history for this message
Joel Montes de Oca (joelmontes01) said : 		#5

Thanks! I will try those suggestions tonight. :)

Revision history for this message
Rodrigo Donado (frezeeer) said : 		#6

Hi:

if the answer solved your question mark it as solved.

Revision history for this message
Joel Montes de Oca (joelmontes01) said : 		#7

Thanks Rodrigo Donado, that solved my question.