Formula related to dates

[pete4107]

Hello all, I've found this forum terrifically useful over the years and have always been able to find the answer to my question by searching previous posts, however I'm a bit stumped with this so hopefully someone can assist. Basically I'm trying to achieve a result whereby by the date in one column is used to calculate whether an target has been met or not. This is slightly complicated by the fact that there are 2 different rules depending on the account. To try and explain that better (and to give an example) I have Project A, and the date it was assigned in one column, the type of project in another (which means it either has a 12 month or 6 month deadline) and another column which I want to show the date by which it need to be complete from the information provided in the previous 2 columns. I hope this makes sense, any information gratefully received. Pete

 

[Aladin Akyurek]

=EDATE(Assigneddate,Type)

where type = 6 or 12.