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