Thomas Kuriakose
Active Member
Respected Sirs,
Good day to you,
I am not able to figure out why the future date in the attached file does not work if the dates are changed.
Our requirement is to arrive at the future date based on issue date (A2) and the tenure (B2) with respect to todays date and then if the year falls in 2019 we need to take action as in Q2 (yes if in current year and no if not in current year).
When I change the issue date to 2019 I get #N/A in future date.
Firstly kindly guide whether the formula in C2 is correct.
I tried to prepare a schedule with EDATE function, but not able to reference the years in D1 to P1 to automate the table for all cells based on the issue date and tenure.
Thank you very much for your support and guidance always,
very much appreciated,
with regards,
thomas
Good day to you,
I am not able to figure out why the future date in the attached file does not work if the dates are changed.
Our requirement is to arrive at the future date based on issue date (A2) and the tenure (B2) with respect to todays date and then if the year falls in 2019 we need to take action as in Q2 (yes if in current year and no if not in current year).
When I change the issue date to 2019 I get #N/A in future date.
Firstly kindly guide whether the formula in C2 is correct.
I tried to prepare a schedule with EDATE function, but not able to reference the years in D1 to P1 to automate the table for all cells based on the issue date and tenure.
Thank you very much for your support and guidance always,
very much appreciated,
with regards,
thomas