Forum Discussion

Josep Maria Niubo Marti's avatar
Josep Maria Niubo Marti
Copper Contributor
Oct 04, 2017

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