Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


     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.