Return a certain cell value if corresponding date.

Okay, So I am trying to return a certain cell value if todays date is within two weeks.

I have a paycheck and hour tracker, and there is a total hours value under every week. I want to know if there is a function to return the hours for that set of weeks if todays date is within that array.

For example, Todays date is October 11th and I have worked 11 hours so far. I want a cell in the very top frozen section, that says “hours worked this week” and displays that number of hours.

 

By: Brandon M Bailey

Leave a Reply

Your email address will not be published. Required fields are marked *