Probabtion Dates

[madmansgates]

Hi,

Has anyone got any ideas on this query:

New employees have a 3 month probabtion before they are given targets. Targets start on the first day of the month after the 3 month probabtion so eg: start date 15-Mar-2011, target starts 1-Jul-2011

i need a formula that picks up the target figure, once the probation is over so:

<TABLE style="WIDTH: 365pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=488><COLGROUP><COL style="WIDTH: 116pt; mso-width-source: userset; mso-width-alt: 3968" width=155><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 2944" width=115><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 2636" width=103><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 2944" width=115><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 116pt; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; HEIGHT: 14.25pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl66 height=19 width=155>Emma Cooker</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl65 width=115>Title 4 -AE</TD><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 77pt; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl67 width=103 align=right>07-Feb-11</TD><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl66 width=115 align=right>5000</TD></TR></TBODY></TABLE>

above, emma started on 7th Feb, so her target starts from 1st june but the 5000 is being picket up from a different table

so i need a formula that will only pick up the 5000 only after 1st June

thanks in advance

 

[bryonwoods30]

would be alot easier if you could just insert another column and say if they are on probation or not. then in the field that pulls the 5000 in, use an if statement saying if they are on probation the field is blank, if not on probation lookup the 5000.

 

[madmansgates]

That's a good idea. I tried it out and worked
Thanks again