IF Function: To update Status on Project Completion dates

zeppelinmike

New member
Joined
Nov 10, 2011
Messages
1
Reaction score
0
Points
0
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!!
smile.gif
 
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,
 
Back
Top