I currently have a formula that calculates either 3 months from the date in column I or 12 months, I also need to calculate 2 weeks in the same column
My current formula is =IF(I3<>"",EDATE(I3,MAX(K3:L3:N3)),"") and works perfection for columns K, L and N which are reading months, but for column M I need it to read 2 weeks.
My current formula is =IF(I3<>"",EDATE(I3,MAX(K3:L3:N3)),"") and works perfection for columns K, L and N which are reading months, but for column M I need it to read 2 weeks.