Forum Discussion
Josep Maria Niubo Marti
Oct 04, 2017Copper Contributor
Weekday formula not working on Excel 2016 Entreprise (PC)
Hello,
I used the following formula on a MAC and it worked well.
=TEXT(WEEKDAY([@Date]),"dddd")
When I now open the same file on a PC (using the same EXCEL 2016 Entreprise software) it does not work.
I try entering the formula again and it shows me error (see attachment)
Note: Data contained on DATE Column is formatted as DATE.
Thanks for your help.
Josep Maria Niubo
1 Reply
- SergeiBaklanDiamond Contributor
It works on PC as well
How is your weekday column formatted?