@Kip_Gordon I built a template similar to what you are requesting using excel formulas. I am sure the commands could be tweaked to your needs. I came across some rather exotic date math formulas but in the end I felt this accomplished what was needed.
The blue represents input items. This obviously could be built out pretty extensively.