Hello, everyone
In my spreadsheet, column H contains the termination date for an ex-employee.
Column I needs to have "Reuse" when the date in column H is 2 years old. Following is the formula I tried using. I receive error message "You've entered too many arguments for this function".
=IF(H13>0,(And(DATE(YEAR(H13)+2,MONTH(H13),DAY(H13),"REUSE""")))
If I remove one of the quotes at the end, I receive error message "The formula you typed contains an error".
=IF(H13>0,(And(DATE(YEAR(H13)+2,MONTH(H13),DAY(H13),"REUSE"")))
Thank you in advance for your help.
Kind Regards,
Linda
Bookmarks