trigger date

[UPN]

Is there a way to trigger a formula to only work when a certain date is reached and keep the result in that cell after that date also

example let say f7 is blank

this cell will be blank till let say 2/24/07, on that day the formula will be done and stay there even after this date.

so on 2/24/07, cell f7 will have perform a formula and put the results in it

 

[barry houdini]

Not sure about the cell references

If the employee start date (e.g. 2/24/1992) is in cell A1 (in any date format) then this formula will show the calculation (L10*8) only when that date is later than 1st September (regardless of the year), otherwise only after the anniversary date in 2007. Is that the requirement?

=IF(OR(MONTH(A1)>8,TODAY()>=DATE(2007,MONTH(A1),DAY(A1))),L10*8,"")

 

[UPN]

sort of

i will see if this works, but the september date is only because of that is when new company bought us, so their policy starts that day.

I will check it out and let you know if it works
thanks for the help

 

[UPN]

one question

will this work when we go into 2007, or will i have to change the formula to 2008?

 

[UPN]

bump

 

[UPN]

bump

when we go into 2007, will this formula still work?
i guess mostly the last part

 

[barry houdini]

As the formula stands if you have the date 2/24/1992 in A1 then L10*8 will only be shown after 2/24/2007.

On which date(s) do you want this to either:

1) revert to blank?
2) start showing 2008 leave?

What is the calculation for future year's leave? Is it still L10*8 or does there need to be a referenec to different cells?

 

[UPN]

answers

L10*8 will always be the cell

show 2007-2008 leave

so on 2/24/07 of my example it will show this person's leave in a cell

Only reason i ask about when go into 2007,
i was wondering is second half of formula will work as the years continue on,

 

[UPN]

bump

bump

our vacation runs from your start date to the next year on that date

so my example 2/24/07 this person would get his vacation on 2/24/2007 and end on 2/23/2008

on 2/24/2008 the person would get his next year vacation

So would the this formula work year to year?

=IF(OR(MONTH(A1)>8,TODAY()>=DATE(2007,MONTH(A1),DAY(A1))),L10*8,"")

the greater then 8 thing was only because this policy didnt start till sept 1 of this year

 

[barry houdini]

As the formula stands, it will continue to show L10*8 from 2/24/2007 onwards, do you want it to show something different from 2/24/2008?

 

[UPN]

no

no want it to do same formula on 2/24/2008