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
