I have a series with most characters appearing in every book. I have been tracking all character info in excel, but the age tracking is becoming too complicated so I'm seeking software that can replace my excel spreadsheets. The feature I would most appreciate is that I can date the timeframe of the book and then the ages will automatically populate. Thank you for any suggestions.
4How to calculate years and months between dates in Excel– AlexanderFeb 20, 2018 at 23:36
To track characters ages over time, I use an Excel spreadsheet even though I use Microsoft Word to track everything else in the series. It's just simpler and easier to find.– MW_writerFeb 22, 2018 at 21:27
You can use a formula to do that in excel, though it isn't the most straightforward formula.
If you're willing to pay, I can suggest Aeon Timeline. You create the events on the timeline (which you can customise to your needs), create a birth event for the characters, assign the characters to the events they participate in (you can further specify if they're active, passive, observers or just mentioned), and the software automatically tells you how old everyone is at any given event.
Thank you for the suggestions. I have purchased Aeon Timeline and it looks like it will help. Feb 21, 2018 at 15:44
2@SheilaKell If you found this answer solved your problem, you can indicate so by accepting it. Simply click the green checkmark outline just below the voting buttons to accept the answer. You can change which answer you have accepted at any time, should an even better answer come along later. Enjoy your stay!– userFeb 23, 2018 at 8:54