View original (French)

CALCULATIONS

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

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

Configuration: Windows 7 / Internet Explorer 9.0

4 réponses

Réponse 1 / 4
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
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
Réponse 2 / 4
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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
Réponse 3 / 4
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
or even

=INT(365.25*10) =3652 J
0
Réponse 4 / 4
Dracknard Posted messages 506 Registration date   Status Membre 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