Forum Discussion

naigen's avatar
naigen
Frequent Visitor
4 years ago

Remove Timestamps from Calendar Date - GetPivot on Excel

Hi all, I'm currently building a model on excel that will allow me to reference a date column in a powerpivot using some excel formulas.  the data is imported via powerquery and dax within excel. ...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, naigen ;

Try it.

1.Click the Home tab

2.In the Number group, click on the drop-down

3.Select Short date (or Long Date) – based on how you want the date to be displayed.

https://trumpexcel.com/remove-time-from-date-in-excel/


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.