Ubuntu
openoffice.org package

I want to use the DAYS function. I have a spreadsheet with 2 columns of dates, and I want to use the function to calculate the no of days including the first and last date.

Asked by Wendy Phelps

I have found the function for DAYS, however I want to be able to pick up Date_1 and Date_2, but don't know how to do it.

This is an example of the dates:
Date_1 Date_2
30/06/08 30/06/08
23/06/08 30/06/08
20/06/08 30/06/08
02/06/08 30/06/08
03/06/08 30/06/08
01/06/08 30/06/08
30/05/08 30/06/08
28/05/08 30/06/08
28/05/08 30/06/08
28/05/08 30/06/08
25/05/08 30/06/08
25/05/08 30/06/08
20/05/08 30/06/08
16/05/08 30/06/08

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Abi ^-^ (abiyasa-eka) said : 		#1

Hello, did you want to calculate the no of days from two column like this

For example :

Date 1 is in column A
Date 2 is in column B

A1=30/06/08
B1=23/06/08

you can use formula

=A1-B1

and the output is 7

isn't it?

Can you help with this problem?

Provide an answer of your own, or ask Wendy Phelps for more information if necessary.

To post a message you must log in.