If date changes in one cell, have text change in another.

Hello!

In cell G10, I have the =now() formula.

Anytime the date changes from that =now() formula to the next day, I would like another cell to change (E44) to the next set of text located in a range on another worksheet ('Commitments'!A3:A17) - in sequential order, and then repeat as the days cycle through. There are 15 lines of text to be displayed, and then continuously repeated.

So example:

G10 = Sept. 22nd
E44 = the text "this place is cool"

When G10 changes to = Sept. 23rd, I'd like E44 to change to the next line of text in the range, "Life is to be lived."

Range = ('Commitments'!A3:A17) =
A3 = "this place is cool"
A4 = "Life is to be lived."
A5 = "Insert text here"
All the way to A:17

I am at a loss if there is an existing formula to do this or if I need to set up a Macro, at which I'm also lost. I am completely open to any and all thoughts you have on making this work. Thank you!

This formula is great - however, I do not have a new quote for each day of the month. The list of quotes is only 15. I could jimmy rig it and just copy and paste the 15 over again. It'd be nice to have it set up to where it simply always puts in the next quote in sequential order, then repeats, after 15.

Thank you - it works with only a minor hiccup. The transition from Sept to Oct, for example - there are only 30 days in Sept, then it's skipping to Oct. 1st. It actually skips the 15th and 1st quote on the new sheet. It goes from the 14th quote on Sept. 30th and then the 2nd quote on Oct. 1st. Any thoughts?

We are settled! Thank you - I didn't see your edit - it now works. Much obliged, seņor.

Let's say, for example -- that I wanted to keep a quote on for 7 days, instead of having it change each new day.

How would that dynamic change the formula?

Thank you! Works like a charm.