I use Google Sheets to calculate my word count & rate for daily writing sessions. I'm trying to come up with a formula that will return the estimated date of hitting a goal, based on my current rate.
For further explanation, my monthly goal is 10,000 words. I enter my daily word count into a new row each day. I have already set up formulas to track my writing rate, and the number of days it will take me to hit the 10,000 word goal based on my current rate. (I also have formulas to track the ideal rate based on the number of days left in the month, so that I can see if I'm ahead of, behind on, or right on schedule.)
What I want to do now is to turn the number of days to hit my goal into a date format (so display "04/12/2020" vs "5.8 days").
Is there a way to add today's date plus the days to goal and get a date back?