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 (easier if the data is formatted 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 version

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

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

See example table 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 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 first formula above
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