I need help with the following date calculations. Help would be greatly appreciated!
"frequency" which equals months, 6,12,24,48
training date due = training date + frequency - one month (or 30 days)
1. If it is January how can I minus one month? I end up with an error.
2. I want the training date due color to change
Frequency = 12
Training date: 1/15/2014
Training date due 12/15/2014 to 1/15/2015 - normal color
Training date due 1/16/2015 to 2/15/2015 - orange
Training date due 2/16/2015 to 3/15/2015 - red
Thanks in advance!