Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Usage of TODAY() in formula
Message
De
11/01/2018 10:08:59
 
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Versions des environnements
Microsoft Office:
Office 2016
OS:
Windows 10
Network:
Windows Server 2012
Divers
Thread ID:
01657091
Message ID:
01657100
Vues:
33
>Either TODAY() or NOW() will work, provided that they are in the right order, that is the second date should always be greater or equal than the first one, weird...
>
>
>=DATEDIF("2019/01/15", "2018/03/17", "d") => #NUM
>=DATEDIF("2018/01/15", "2018/03/17", "d") => 61
>=DATEDIF(TODAY(), "2018/03/17", "d") => 65
>=DATEDIF(TODAY(), "2017/03/17", "d") => #NUM
>=DATEDIF("2017/03/17", TODAY(), "d") => 300
>
Thanks, this works.

I had to remove the equal sign.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform