format to allow the
counting of days lapsed between a "from a date" cell and a "to a date' cell
To: users@global.libreoffice.org
Date: Tuesday, 24 January, 2012, 14:38
Am 24.01.2012 15:17, Tom Davies wrote:
> Hi :)
> I think for data-entry it is best to enter the date as
&g
Am 24.01.2012 15:17, Tom Davies wrote:
Hi :)
I think for data-entry it is best to enter the date as
01/24/2012
If you want to enter dates of the current month (January 2012 at the
time of this writing) then you simply enter
1/
13/
4/
30/
15/
This will enter the *correct cell values* _unless_
rote:
From: MSwhip
Subject: [libreoffice-users] Re: How to enter Dates in a format to allow the
counting of days lapsed between a "from a date" cell and a "to a date' cell
To: users@global.libreoffice.org
Date: Tuesday, 24 January, 2012, 12:58
This is my reply to all of y
Am 24.01.2012 13:58, MSwhip wrote:
This is my reply to all of you that made suggestions or stated your views.
They were all very useful.
With regards to the question about what exactly I was asking, the first
issue was ...should I enter the date as "24 January 2012," or "January 24
2012" or '0
This is my reply to all of you that made suggestions or stated your views.
They were all very useful.
With regards to the question about what exactly I was asking, the first
issue was ...should I enter the date as "24 January 2012," or "January 24
2012" or '01/24/2012' or 24/01/2012 for the sof
Am 19.01.2012 09:27, MSwhip wrote:
I am interested in learning how to enter dates in cells in a format that
would allow me to calculate number of days lapsed between a "from date" and
a "to date" entered in 2 different cells.
Could anyone please help
Thank you
Date entry works almost indepen
Hi:
You only have to input like this example:
in cell A1 : 10/12/2011
in cell B1 : 12/12/2011
in cell C1 : +B1-A1 ---> Result = 2 in cell C1
Regards,
Jorge Rodríguez
___
El jue, 19-01-2012 a las 08:25 -0800, Tom escribió:
> Hi :)
> I think you are no
Here is how I do it. I use Column A for the beginning date,Column B
for the ending date, and Row 1 for the column headings.
I enter the first beginning date in cell A2 and first ending date
in cell B2. I continue adding the beginning and ending dates down these
two columns.
In cell C
Hi :)
I think you are not fully subscribed to the list yet. Is there a
"confirmation email" waiting in your spam/junk folder?
Don't you just format the cells as Dates rather than numbers or text and
then just do one cell - the other and have the answer cell formatted as date
too?
Regards from
Tom