Forum Discussion
Excel Formulas
can anyone help me please, i need to create a spreadsheet with a list of people with expiry dates for a particular certification expiry date, i would like to put in a formula to give me a 6 month war...
Sorry about that. I left off a closing parenthesis after the first A1. It should read: =DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))