Re: [libreoffice-users] Compute difference

Thanks Tom

Dear Dave

It does work - you have to format the input  cells as stated.

b4 is formatted to Date, 31/Dec
c4 is text "to"
d4 is formatted to Date, 31/dec

then in

E4 =days360(b4,d4,3)

then input your 2 dates into b4 and d4     as in just type:-  01/07/2011 and
22/07/2011

and the answer in E4 is 21

you might want to add +1 to the E4 formula depending on if you decide 
the answer in E4 should be 22

I note that 1/7/2011 is the same as 01/07/2011, as is just 1/7 (as it 
auto inputs this year)

regards

John B

----------------------------------------------------------------------------------------------

On 22/07/2011 20:41, Tom Davies wrote:
> Hi :)
> I think John's answer was mostly so you could copy&paste into the right places!
>
>
> To do the formatting in the first part of his answer click on the cell and then
> look up at the menus at the top of the LibreOffice window.  The menus should be
> something like
>
> File  ..  View ... Edit ... (err i can't remember) ... Format ... (more i can't
> remember) ... Window ... Help
> So, click on the "Format" menu, choose  "Cell" and a pop-up box should appear
> with lots of "tabs" at the top.  Choose the first one, "General" (or
> something).  Somewhere on the left should be an option for "Date" which then
> gives you various sub-options.
>
> Hope this helps but there is a guide with screen-shots somewhere that might help
> so don't worry if it's not obvious.  See Chapter 5
>
> http://www.libreoffice.org/get-help/documentation/
> Regards from
> Tom :)
>
>
>
>
> ________________________________
> From: Dave Douglas<ddouglas1@farmersagent.com>
> To: users@global.libreoffice.org
> Sent: Fri, 22 July, 2011 20:06:33
> Subject: Re: [libreoffice-users] Compute difference
>
> Thanks, but I am not a programmer.  I have troubles being understood in
> English.  Is there a way of doing it through the menus?
>
> Feeling unworthy,
> Dave
>
>
> -----Original Message----- From: John B
> Sent: Friday, July 22, 2011 12:00 PM
> To: users@global.libreoffice.org
> Subject: Re: [libreoffice-users] Compute difference
>
> Try this
>
> b4 is formatted to Date, 31/Dec
> c4 is text "to"
> d4 is formatted to Date, 31/dec
>
> E4 = ((-B4+D4)/7 +(1/7)
>
> f4= Trunc(e4)
>
> g4= (+e4-F4)*7
>
>
> then type in your 2 dates into b4 and d4     as in  01/07/2011 and
> 22/07/2011
>
>
> regards
>
> John B
>
> --------------------------------------------------------------------------------
>
>
>
>
>
> On 22/07/2011 15:15, Jérôme Fenal wrote:
> > Hi all,
> >
> > I need to do a difference in days between two dates, _without_ taking into
> > account leap years (e.g. considering all years are 365 days long).
> >
> > The right way to do that would be to use function
> > DAYS360(date1;date2;method) using method = 3 as in other financial
> > functions, but it does seems to be implemented (only 0&   non 0 are
> > meaningful for this function currently).
> >
> > Does anybody know how to still do this without ressorting to a procedural
> > language ?
> >
> > Regards,
> >
> > J.
> >
> > PS: I'll be digging into BZ to see if there is already a request for such an
> > enhancement to DAYS360().
> >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11
> > 16:13:00
>
> -- 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
>
>
> Introducing the Farmers Value Program - Big Discounts on Business Services
>
> Visit us on the web at
> http://www.farmersbusinessinsurance.com/farmers-value-program.html
>
>
>
> -- 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


--
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