Hi Everyone!
I am new to using functions and trying to learn. Right now I want to combine several functions into one cell. I am trying to create a function that will project a yearly totally based on performance year-to-date. I can do this in several cells, but I want to combine them somehow, if I can. To do this step-by-step, I do the following functions.
1. Calculate the total so far (in my case it is a daily reading/studying tally).
2. Calculate the day of the year.
3. Calculate the average daily reading hours.
4. Multiply the average daily reading hours by 366 (since it is leap year) to determine how many hours I am on track to read by the end of the year.
Here are the functions I am using.
=SUBTOTAL(109,[Time])
=TODAY()
=B257-DATE(YEAR(B257),1,0) [where B257 is the TODAY() function immediately above.]
=Table1[[#Totals],[Time]]/B258 [B258 being the day of the year function immediately above.]
=B259*366
I learned how to combine the TODAY() function and the DATE to calculate the day of the year in one function,
=TODAY()-DATE(YEAR(TODAY()),1,0)
but when I try to put all other elements together
=Table1[[#Totals],[Time]]/TODAY()-DATE(YEAR(TODAY()),1,0)*366
I get some funky number like -15507054
How can I do this all in one cell?
Thanks in advance.
Bookmarks