Hello, in order for this to make more sense, as I have a hard time explaining what I want to do, here is a little context. I am a wedding photographer, and what I want to be able to do is have a template spreadsheet of a specific timeline revolving around one date: the wedding day. I want to be able to enter the wedding day date, and have my other events (dates) automatically change dates according to that one date. e.g.: 2 weeks after, 30 days before, 4 and half months before...etc, Without having to count out the days every time.
The template spreadsheet would include all these other events I want to add around the wedding day. They stay the same for every wedding.
Every wedding is the same (timeline wise), so to have this template automatically populate a monthly calendar with different titles for every couple, that would save so much time.
Am I making sense? Is this possible?
Thanks!
Bookmarks