ADD today's date in french

I am not sure if Airtable has support for any language other than English.

If not you could create a nested IF formula to take the month number and convert it to the word in French.

You will need one column that is titled “Date”, then another column that is a formula with the following. I only went up to Mai but you can continue the formula to complete the rest of the year.

IF(MONTH(Date) = 1, DATETIME_FORMAT(Date,"D") & " " &"Janvier",IF(MONTH(Date) = 2,DATETIME_FORMAT(Date,"D") & " " &"Février",IF(MONTH(Date)=3,DATETIME_FORMAT(Date,"D") & " " &"Mars",IF(MONTH(Date)=4,"Avril",IF(MONTH(Date)=5,DATETIME_FORMAT(Date,"D") & " " &"Mai")))))

You can do this with Switch statement too.

Welcome to the Airtable community! You can use SET_LOCALE in conjunction with DATETIME_FORMAT to get a text version of a date in the language of your choice.

DATETIME_FORMAT(
  SET_LOCALE(
    {Date},
    'fr'
  ),
  'D MMMM'
)

DATETIME_FORMAT(
  SET_LOCALE(
    {Date},
    'fr'
  ),
  'D MMMM'
)

Thanks @kuovonne I was not aware of Set_Local, good to know.