Forum Discussion
Solved
Formulas and Functionsn
Hi, How to change format in =TODAY()+5 to dd-mm-yyyy format?
- Use TEXT() function to apply the desired format. =TEXT(TODAY()+5,"dd-mm-yyyy"). You also apply same format to cell formatting rule.
Use TEXT() function to apply the desired format. =TEXT(TODAY()+5,"dd-mm-yyyy"). You also apply same format to cell formatting rule.
It works – the result displayed is left-adjusted. But when I use =TODAY(), the result is displayed as right-adjusted in the cell. Thanks much, Harun! Good day.