ads_3131
03-08-2012, 02:14 AM
Hello!!!!
Attached i have a retirement spreadsheet that i have created, it works apart from one feature that i cannot get my head around.....
Currently i put a users d.o.b in and it calcs the date of retirement and places the word "Retirement" in the cell allocated to the date......
What i need help with is, If the cell says "retirement" put the text "Inform" 6 months before?
Can this be done?
Attached is my spreadsheet....
Attached i have a retirement spreadsheet that i have created, it works apart from one feature that i cannot get my head around.....
Currently i put a users d.o.b in and it calcs the date of retirement and places the word "Retirement" in the cell allocated to the date......
What i need help with is, If the cell says "retirement" put the text "Inform" 6 months before?
Can this be done?
Attached is my spreadsheet....