Skip to main content

Statistics

Day-to-day statistics

To prepare statistics on articles, you can use advanced searches and data exports to get the source data. From then on, you can handle common statistics requests using pivot tables in your favorite spreadsheet program.


Delay computations

Concerning delay computation between two dates, use the following formulas in Excel (to use column headers, format your data as a table).

1 Submission date
 Final decision date
 From submission to final decision (formula)
2 25/05/2023 27/06/2023 24
3 25/05/2023


Standard formula
=IF(OR(A2="",B2=""),"",DAYS(A2,B2))

French Excel version

=SI(OU(A2="";B2="");"";JOURS(A2;B2))

Recommended: column headers, needs data to be formatted as a table

See example below:

  • Any missing date will output a null result (= no delay computed)
  • A negative result highlights a workflow issue, and is thus output as N/A

Formula

=IF(
    OR([@[Publication date]]="", [@[Submission date]]=""),
    "",
    IF(
        [@[Publication date]] - [@[Submission date]] >= 0,
        [@[Publication date]] - [@[Submission date]],
        "N/A"
    )
)

French Excel version

=SI(
    OU([@[Publication date]]=""; [@[Submission date]]="");
    "";
    SI(
        [@[Publication date]] - [@[Submission date]] >= 0;
        [@[Publication date]] - [@[Submission date]];
        "N/A"
    )
)
Submission date Publication date

Submission to publication, with the above formula
04/11/2025 02/01/2026 59
07/11/2025 03/01/2026 57
15/11/2025

17/11/2025 15/11/2025                                                              N/A
Back to top