Forum Discussion
Karla Tharin Hakansson
Jan 04, 2018Copper Contributor
How to use date forumla
Found this awesome https://templates.office.com/en-us/Timeline-with-milestones-yellow-TM03987160, but can't figure out how to use the dates without messing up the formula. Can anyone help?
Tha...
SergeiBaklan
Jan 04, 2018Diamond Contributor
Hi Karla,
In Date column of the table you may insert any date in your local format instead of formula. If in template
=DATE(YEAR(TODAY()),2,24)
you may simply change it on 2018-02-24 (in my locale I use ISO date format).
If you'd like to change date format in graph double click on axis with dates and change template format
on any one your prefer. e.g.