Posted December 18, 201113 yr 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...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.