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