I have entered a formula and it works fine in my excel sheet that I have saved, but when I send it out to others through email and they open the sheet the formula gives the a #NAME error. Why would this be and what do I need to solve this?
The formula is
=Weekday(Today(),-1)
The formula is
=Weekday(Today(),-1)