{"id":6815,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/aujourdhui\/"},"modified":"2021-02-26T08:15:22","modified_gmt":"2021-02-26T08:15:22","slug":"today","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/today\/","title":{"rendered":"AUJOURDHUI"},"content":{"rendered":"

La fonction AUJOURDHUI, est un outil tr\u00e8s pratique dans Microsoft Excel et Google Sheets pour le traitement des dates. Elle permet de renvoyer la date actuelle du syst\u00e8me, qui se met \u00e0 jour automatiquement \u00e0 chaque recalcul de la feuille. Dans cet article, nous examinerons comment utiliser cette fonction en d\u00e9tail, en pr\u00e9sentant sa syntaxe et en illustrant son utilisation \u00e0 travers des exemples pratiques.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction AUJOURDHUI est extr\u00eamement simple, car elle ne requiert aucun argument.<\/p>\n

AUJOURDHUI()<\/code><\/pre>\n
Lorsqu’elle est saisie dans une cellule, AUJOURDHUI renvoie la date courante, format\u00e9e selon les param\u00e8tres de date par d\u00e9faut de votre syst\u00e8me ou de votre logiciel de tableur.<\/p>\n
Exemples d’utilisation<\/h2>\n
Explorons quelques exemples pour voir comment int\u00e9grer AUJOURDHUI dans vos feuilles de calcul.<\/p>\n
    \n
  • Pour afficher directement la date d’aujourd’hui, tapez ‘=AUJOURDHUI()’ dans une cellule.<\/li>\n
  • Pour calculer l’\u00e2ge en ann\u00e9es \u00e0 partir d’une date de naissance situ\u00e9e en cellule A1, utilisez ‘=DATEDIF(A1, AUJOURDHUI(), \u00ab\u00a0y\u00a0\u00bb)’.<\/li>\n<\/ul>\n
    Applications pratiques de AUJOURDHUI<\/h2>\n
    Voici deux sc\u00e9narios o\u00f9 la fonction AUJOURDHUI peut s’av\u00e9rer tr\u00e8s utile.<\/p>\n
    Cas pratique 1 : Suivi d’une date limite<\/h2>\n
    Imaginez que vous g\u00e9rez un projet et vous devez v\u00e9rifier si la date actuelle d\u00e9passe une \u00e9ch\u00e9ance fix\u00e9e en cellule B1. Configurez cela comme suit :<\/p>\n
    Diff\u00e9rence de jours: =AUJOURDHUI() - B1<\/code><\/pre>\n
    Si le r\u00e9sultat est positif, cela indique que la date limite a \u00e9t\u00e9 d\u00e9pass\u00e9e. Vous pouvez \u00e9galement utiliser la mise en forme conditionnelle pour faire changer la couleur de la cellule en rouge si la date est d\u00e9pass\u00e9e, selon cette formule.<\/p>\n
    Cas pratique 2 : Calcul de l’\u00e2ge<\/h2>\n
    Un autre usage fr\u00e9quent d’AUJOURDHUI est dans le calcul de l’\u00e2ge \u00e0 partir d’une date de naissance. Si cette date est dans la cellule C1, la formule serait :<\/p>\n
    \u00c2ge: =DATEDIF(C1, AUJOURDHUI(), \"y\")<\/code><\/pre>\n
    Cette formule d\u00e9termine le nombre d’ann\u00e9es compl\u00e8tes \u00e9coul\u00e9es entre la date de naissance et la date actuelle, tr\u00e8s utile tant dans des contextes administratifs que personnels.<\/p>\n
    En r\u00e9sum\u00e9, la fonction AUJOURDHUI est simple d’utilisation mais offre des capacit\u00e9s puissantes pour la gestion de donn\u00e9es relatives aux dates dans Excel et Google Sheets. Elle est id\u00e9ale aussi bien pour le suivi des \u00e9ch\u00e9ances que pour le calcul de l’\u00e2ge, offrant un moyen de calcul dynamique qui se met \u00e0 jour en fonction du temps qui passe.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le num\u00e9Ro de s\u00e9Rie de la date du jouR<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[321],"tags":[],"class_list":["post-6815","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TODAY (AUJOURDHUI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/today\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TODAY (AUJOURDHUI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/today\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:15:22+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/today\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/today\/\",\"name\":\"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:15:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TODAY (AUJOURDHUI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/today\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/today\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/today\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Date et heure\",\"item\":\"https:\/\/functiontranslator.com\/fr\/date-et-heure\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"AUJOURDHUI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TODAY (AUJOURDHUI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/today\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TODAY (AUJOURDHUI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/today\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:15:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/today\/","url":"https:\/\/functiontranslator.com\/fr\/today\/","name":"Fonction TODAY (AUJOURDHUI) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:15:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TODAY (AUJOURDHUI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/today\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/today\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/today\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Date et heure","item":"https:\/\/functiontranslator.com\/fr\/date-et-heure\/"},{"@type":"ListItem","position":3,"name":"AUJOURDHUI"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6815"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6815\/revisions"}],"predecessor-version":[{"id":29824,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6815\/revisions\/29824"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}