View original (French)

CALCULATIONS

smart19 -  
Hello,

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

Configuration: Windows 7 / Internet Explorer 9.0

4 answers

  1.  gbinforme Contributor
    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
    1. Mike-31
      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.
      2. Dracknard
        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.