After a lot of research, I have failed to figure this out. I want a calendar that looks like a wall calendar but with text functions. I need a formula that will allow me to enter a predetermined word and number anywhere on the calendar and it return a different text with the same number in a different cell. Example; if I type "Dog 101" in any cell it will return "Cat 101" in a cell that is 7 cells past Dog. If I type "Dog 101" on January 1 it will return "Cat 101" on January 8. Also more returns would return "Cow 101" 14 days later and so on. Thanks