Hi,
So I´m using the following formula:
=IF(C2="Pre-sessional only",EDATE(F2,1),IF(O(C2="English",C2>=1,C2="Foundation"),IF(DATEDIF(E2,F2,"m")<=6,(F2+7),IF(DATEDIF(E2,F2,"m")<12,EDATE(F2,2),IF(DATEDIF(E2,F2,"m")>=12,EDATE(F2,4))))))
I realise the above formula could be simplified but my question regards difference between months which remains regardless.....
In the formula above when the difference between two dates I´m using is less than 6 months, between 6-12 months or more than 12 months, I want to add 7 days, 2 months or 4 months respectively, to a given date.
The problem is that the formula only recognizes >6 months if the difference between the two dates is 7 completed months. It doesn´t recognize a difference of 6 days and 1 day for example as more than 6 months. Equally it doesn´t recognize that 12 months and a day is greater than 12 months. How do I solve this? I would use days instead but not every month has 30 days etc.
Is there a formula that recognizes that 6 months a say 10 days is more than 6 months (even though it´s less than 7 months, or that 12 months and 2 days is more than 12 months (even though it´s less than 13 months?
I´m sure there is a simple answer but I´m an Excel novice!!!
Thank you
Bookmarks