Why cant i get this formula to work on Excel mobile but it works in Excel

[Trewend]

Why cant i get this formula to work on Excel mobile but it works in Excel

=TEXT(C6-DATE(YEAR(C6),1,0),"000")

Where C6 = =DATE(2011,12,30)

I am trying to calculate the day of the year by altering the date in C6

Continue reading...