Google Sheets: How to Format Today's Date with TEXT(TODAY(), 'dd-mmm-yyyy')
Use natural language to write 'today date format' with AI
Google Sheets Date Formatting Guide
The formula TEXT(TODAY(), 'dd-mmm-yyyy') in Google Sheets is used to display the current date in a specific format.
To use this formula, simply type it into a cell in your Google Sheet. When you press enter, the cell will display the current date in the format "dd-mmm-yyyy" (e.g. 01-Jan-2022).
This formula is useful for automatically updating the date in your spreadsheet without having to manually input it each day.
Now you can use simple words to process data. It's at CapGo AI Sheet. For Google Sheet formula '=TEXT(TODAY(), "dd-mmm-yyyy")':
You can write a simple instruction "Format the current date in #A as 'dd-mmm-yyyy'."
In 1 second, all your data is processed!
