How to I get excel to reference to a different cell incrementing each day?

Related Quote Of The Day Articles
Question by agill15806: How to I get excel to reference to a different cell incrementing each day?
I have a spread sheet that is my training schedule for running, what I want to do is have a different motivational quote each day. The list of quotes starts at A50. I have another cell that is =DAY(TODAY()) which gives the numerical day, for instance today it shows 18, tomorrow it will show 19. That might help, might not.

I want my A4 cell to reference A50 today, but A51 tomorrow.

Best answer:

Answer by LDP
Insert this formula into cell A4: http://pastebin.com/tT9epWGx

Note that I have adjusted it for your date (according to you, today is 18th but over here it is the 19th). If the date has changed to the 19th by the time you read this, you need to change the 41108 to 41109.

The formula I have given should automatically increment the row by 1 everyday, so there will be no need to alter/change it.

What do you think? Answer below!

Move Further @ http://www.elevatedonlinebusiness.com/TopTier Success Quotes With Relaxing Music & Nature Scenes For Subconscious Mind Power Success Quotes ar…
Video Rating: 5 / 5