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!!
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!!