PDA

View Full Version : IF Function: To update Status on Project Completion dates



zeppelinmike
2011-11-10, 10:42 PM
Hi guys, can you help me please?

I need to insert an IF function on the following information

As shown below I have a Deadline Month in A2 and a Completion Month in B2.
C2 is a Status field based on the progress of whether the deadline has being completed within less than < 6 months or greater > 6 months or greater than >12 months. ( I currently manually enter in the Status progress whether its "Within Deadline"- (WD), "Beyond Deadline"-(BD) or "Completed".

I want to create the Status automatically for me.


Deadline Month Completion Month Status
Jul-11 Nov-11 WD
Feb-11 Sep-11 BD
Mar-11 Mar-11 Completed


Your help would be greatly appreacited!!http://www.excelforum.com/images/smilies/smile.gif

Ken Puls
2011-11-11, 07:21 AM
Hi there, and welcome to the forum!

Assuming Deadline Month is in A6 and Completion Month is in B6:
=IF(DATEDIF(A6,B6,"m")<=6,"WD",IF(DATEDIF(A6,B6,"m")>=12,"Completed",IF(DATEDIF(A6,B6,"m")>6,"BD","")))

Hope it helps,