Returning end date of a lease term based on term and type

Hi Folks,

I have a lease table with that has terms set in Months and Fortnights. Attached is a sample file, and I'd like to calculate the date when the lease ends based on the criteria. Please do let me know if my requirement is not spelt out clearly

Thanks for your help

Best,
SJ

Try this:

=IF(F3="months",EDATE(C3,E3),IF(F3="fortnightly",EDATE(C3,E3/2)+MOD(E3,2)*15,""))

Thanks a lot for solving it
Best
SJ

Originally Posted by Phuocam

Try this:

=IF(F3="months",EDATE(C3,E3),IF(F3="fortnightly",EDATE(C3,E3/2)+MOD(E3,2)*15,""))

Thanks Phuocam!