View original (French)

CALCULATIONS

smart19 Posted messages 1 Registration date   Status Member Last intervention   -  
Dracknard Posted messages 506 Registration date   Status Member Last intervention   -
Hello,

WHAT IS THE EXACT NUMBER OF DAYS DURING A 10-YEAR PERIOD

Configuration: Windows 7 / Internet Explorer 9.0

4 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    you have the choice, for example with: 

    =DATE(2010,12,31)-DATE(2000,12,31) or =A1-B1

    with A1 being the start date and B1 the end date, and you should be a bit over 3650 due to the leap years.
    --
    Always zen
    Perfection is attained not when there is nothing more to add, but when there is nothing more to take away. Antoine de Saint-Exupéry
    0
  2. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    And if the calculation is based on a start date in A1 for example

    =DATEDIF(A1;EDATE(A1;120);"d")
    or
    =DATEDIF(A1;DATE(YEAR(A1)+10;MONTH(A1);DAY(A1));"d")

    --
    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    0
  3. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    or even

    =INT(365.25*10) =3652 J
    0
  4. Dracknard Posted messages 506 Registration date   Status Member Last intervention   119
     
    Or else

    In A1 your start date of the period

    In A2 your end date of the period

    In A3: A2-A1+1

    Why the plus 1? Because with this method, the start date of the period is not counted as 1.
    0