d = trainingDate ;
Date ( Month ( d ) + frequency - 1 ; Day ( d ) ; Year ( d ) )
2. You need three Conditional Formatting calculations along the lines of
cTrainingDateDue >= Date ( 12 ; 15 ; 2014 ) and cTrainingDateDue <= Date ( 1 ; 15 ; 2015 )
For question 2,
training date due is calculated by formula in 1, then according to it example should be a day.
Training date due is 12/15/2014
I guess you mean compare the date with "current date"?
Get(CurrentDate) is between Training date due and Training date due + 1month normal
Hello User - Thanks for the question:
Here is what I wanted:
TrainingDateDue is 1 month <= today through today; orange (IOW - for the last month including today) it should be orange
TrainingDateDue is > today ; red
Here is what works:
TrainingDateDue ≥ (Today - 30 ) and TrainingDateDue ≤ Today ; TextColor ( TrainingDateDue ; RGB ( 244 ; 140 ; 20) );
Today > TrainingDateDue; TextColor ( TrainingDateDue ; RGB ( 255 ; 0 ; 0)) ;