I'm trying to use excel to set up when someone is being promoted it will auto
do it

lets say Private first class gets promotion in two years it would auto due
it on its own

is that possible if not with excel then with what producted