Please Register to Remove these Ads
I have 2 questions actually.
1. I know nothing about financial formulas. I need a formula for:
If I invest $1000.00 in a ** at 5.35% AYP, how much money would the **'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
Annual Percentage
to rate it
Linear Mode
