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
=IF(OR(Table1[@[First referee invitation date]]="";Table1[@[Submission date]]="");"";DAYS(Table1[@[First referee invitation date]];Table[@[Submission date]]))In French
=SI(OU(Tableau1[@[First referee invitation date]]="";Tableau1[@[Submission date]]="");"";JOURS(Tableau1[@[First referee invitation date]];Tableau1[@[Submission date]]))| Production date | Publication date |
Production to publication, with the formula: =IF(OR(Table1[@[Publication date]]="";Table1[@[Production date]]="");"";DAYS(Table1[@[Publication date]];Tableau1[@[Production date]])) |
| 04/11/2025 | 02/01/2026 | 59 |
| 07/11/2025 | 03/01/2026 | 57 |
| 15/11/2025 | ||