IF Statement Updates Daily Using TODAY

[MrNerd]

Our goal: Run 2018 miles in 2018.

What I have done: Added multiple sheets where each runner can log their miles separately via the Google Sheet for each day of the year.

What I want to do: Take the remaining miles (updated into the Total sheet in C2) and the remaining days in the year based on the automatically updating =TODAY () formula to give us how many miles a day we need to average to reach our goal. Right now, it is done =C2/356 but I need to manually update the denominator. I do not want to have to go into the Google Sheet everyday to update if I can figure out a formula to do it for me.

(I have added a "1" in the A column of each sheet next to each date thinking that would make it more simple to figure out a formula. Let me know what you think.

MrNerd

 

[Joe4]

Welcome to the Board!

Use this formula to get how many days left in the year:

=DATE(YEAR(TODAY()),12,31)-TODAY()

 

[MrNerd]

Perfect! I figured it was an easy answer.

Thanks for the help and I will definitely be back for more.

 

[Joe4]

You are welcome.
Glad we could help!