View original (French)

Average of dates excel - Page 2

Previous
  • 1
  • 2
  1. sonyblanc
     
    There is a small issue; when I apply the formula, I observe an error regarding the month, there is a one-month shift. What should I do now?

    04/04/1977 04/05/1900
    02/04/1978 02/05/1900
    10/04/1979 10/05/1900
    11/04/1980 11/05/1900
    07/04/1981 07/05/1900
    05/04/1982 05/05/1900
    0
    1. Sir_DEC Posted messages 143 Status Member 75
       
      You must keep the numeric format on the right, calculate the average of the column (still in numeric format), then use MOD and INT; it works and the offset is not present.
      0
  2. calculMan
     
    I entered all the dates with the same year and I display dd/mm in cell format and I add a column on the left with the year.

    15/03/2010 formatted -> 15/03
    16/03/2010 formatted -> 16/03
    17/03/2010 formatted -> 17/03

    Average(B1:B3) => 16/03/2010 formatted -> 16/03
    Column A -> year 2008
    2009
    2010
    0
Previous
  • 1
  • 2