Data input based on date list?

G

Guest

Need some help filling a cell with the corresponding percentage based on date.


Cell A1 is formatted to input today's date based on the computers date.
Formula: =TODAY()

Column F contains all the days of the year

Column G contains the percentages I would like to be at for each day of the
year.

What I would like is....When I open the worksheet when I get to work, I
would like cell C2 to somehow bring in the percentage that corresponds to
today's date. For instance, On 12 Feb when I open my spreadsheet, I would
like cell C2 to automatically update to 10.41% (The date 12 Feb is listed in
Cell F23, and 10.41% is listed in Cell G23.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Changing Sum Range Based on Date Chosen from Drop Down List 1
How input today's date and keep that date 3
Changing values in cell based on system date 2
Percentage over a date range 3
Excel Import Comments 3
Counting days from a date 3
Sum column A:? where ? is a number in a cell somewhere 2

Top