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 C2, I enter this formula: =B2-A2. That is I enter the equal
sign followed by B2 followed by a minus sign followed by A2. Use the
Enter key to enter this formula into cell C2.
Click cell C2, and you should see a little box at the bottom right
of the outline of this cell. Use the mouse cursor to drag it down column
C until you come to the last pair of beginning and ending dates. This
will give you the number of days that exist between each pair of dates.
--Dan
On Thu, 2012-01-19 at 08:25 -0800, Tom wrote:
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 :)
--
View this message in context:
http://nabble.documentfoundation.org/How-to-enter-Dates-in-a-format-to-allow-the-counting-of-days-lapsed-between-a-from-a-date-cell-and-al-tp3671720p3672798.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.