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