Column A is hire date
Column B is date of birth
If their birthday is this month, I need to change the font to red in column B for that employee.
3 Months after hire, I need column C to read "3 mos."
Every 6 months after the hire date, I need put the date of their upcoming review in Column C. If it is their annual, this also needs to be in red.
For example,
A=08/24/04
B=01/08/74
If it is November, Column C needs to read 3 mos.
If it is February, Column C needs to read 2/24/06 (current year) in black
If it is August, Column C needs to read 8/24/06 (current year) in red
If it is January, column B needs to appear in red
Any help would be appreciated.
Thanks!
Column B is date of birth
If their birthday is this month, I need to change the font to red in column B for that employee.
3 Months after hire, I need column C to read "3 mos."
Every 6 months after the hire date, I need put the date of their upcoming review in Column C. If it is their annual, this also needs to be in red.
For example,
A=08/24/04
B=01/08/74
If it is November, Column C needs to read 3 mos.
If it is February, Column C needs to read 2/24/06 (current year) in black
If it is August, Column C needs to read 8/24/06 (current year) in red
If it is January, column B needs to appear in red
Any help would be appreciated.
Thanks!