Formule excel

Mobile apps
1

ONLYOFFICE Mobile: Documents / Projects / Web Editors
Do you want to: Suggest a feature / Report a bug / Ask a how-to question
For feature suggestions, describe the result you would like to achieve in detail.
For bug reports, provide the steps to reproduce and if possible a minimal demo of the problem.
Device:
OS version:
App version:
Mode: Connect to Cloud / On Device
Additional information:
Any relevant details about the situation. You can also attach images and videofile to the post (or to place them to external storage)

Bonjour,
Comment créer ces formules Excel dans onlyoffice :

  • trouver la date de Pâques pour une année.
  • trouver la date du 3ème dimanche de septembre.
  • trouver le 3ème ou 4ème ou 5ème jour ouvrable d’un mois.
    Je vous remercie et vous souhaite une belle journée.
    Olivier Neumann
    Sugiez FR
2

Hello @Olivemann

First of all, please note that official languages of this forum are English and Chinese. I suggest continuing communication in one of these.

In general, all regular formulas are supported, so you can use any suitable for your formula for your tasks. For instance:

  1. To find Easter – I am defining “2025” in cell A1 to indicate in which year I am looking for Easter date, then in B1 use formula =FLOOR(DATE(A1,5,DAY(MINUTE(A1/38)/2+56)),7)-34, which returns that the Easter in 2025 is on the 20th of April;
  2. To find 3d Sunday of September 2025 – I am defining first day of September 2025 in cell A2, the cell B2 I am using formula =DATE(YEAR(A2),MONTH(A2),22)-WEEKDAY(DATE(YEAR(A2),MONTH(A2),0)), which returns that the 3d Sunday of September 2025 is on the 21st of September;
  3. To find Nth day of a month – I am defining current date in cell A3, then in B3 using formula =WORKDAY.INTL(A3-DAY(A3),3,1), which shows that the 3rd workday in June is on the 4th. In this formula Nth day is defined after second A3 reference, i.e. =WORKDAY.INTL(A3-DAY(A3),Nth,1).

image
image704×282 6.25 KB

These are just examples from desktop version of the editors, but these formulas should work fine in the mobile app too.

There are plenty of examples across the Internet you can take as a reference.