Excel: How to Format Today's Date with TEXT(TODAY())
Use natural language to write 'today date format' with AI
Excel Formula Guide
The Excel formula TEXT(TODAY(), 'dd-mmm-yyyy') is used to display the current date in a specific format.
The TODAY() function returns the current date, and the TEXT function is used to format this date in the 'dd-mmm-yyyy' format.
To use this formula, simply enter it into a cell in Excel and press Enter. The cell will display the current date in the format of day-month-year (e.g. 01-Jan-2022). The date will automatically update each time the spreadsheet is opened or recalculated.
Now you can use simple words to process data. It's at CapGo AI Sheet. For example, for excel formula '=TEXT(TODAY(), "dd-mmm-yyyy")':
You can write a simple header "Format the current date in #A as 'dd-mmm-yyyy' using a formula."
In two seconds, all your data is processed!
