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+h...@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
