Calculate a monthly date and a weekly date in the same column

[wlbamc]

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.

 

[Fluff]

Duplicate to: Date Formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.