Thread: Annual Percentage

I have 2 questions actually.

1. I know nothing about financial formulas. I need a formula for:
If I invest $1000.00 in a CD at 5.35% AYP, how much money would the CD's value be at the end of 12 months? How much would it make daily and monthly?

2. I have a column of dates which represent the day an employee attended training. I was trying to conditionally format the column so that the date would turn blue if it came within 30 days of this specific date a year from now to indicate that the time for re-training was close and red if it were past the date for re-training.
(Ex: 5/31/07......the date would turn red anywhere from 5/1/08 til the date and a different color if past that day - 5/31/08)


Thanks,
Don