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]

The formula should be OK as it stands, the OR means that only one of the conditions has to be true, so once the 2007 date has passed it will always show L10*8 no matter what the month

 

[UPN]

ok

ok thanks i don't know much about the OR command

thanks for the help

 

[UPN]

need a little more help

=IF(OR(MONTH(C4)>8,TODAY()>=DATE(2007,MONTH(C4),DAY(C4))),G3*8," ")

I need to add to this so that is doesnt put the person vacation time in the cell before there anniversary date.

Problem being some have already past since sept 1, which will have to show but not anyone if have a anniversary date still not here.

I am not sure if this will be a problem also when we enter into new year

thanks in advance for help

 

[UPN]

bump

 

[UPN]

need help

=IF(OR(MONTH(C4)>8,TODAY()>=DATE(2007,MONTH(C4),DAY(C4))),G3*8," ")

The above code is in cell F6

i presented by spreadsheet to boss, they liked it but for one thing.

It is working like I think it should be, but the problem is they dont want a person vacation showing till their hire date is reached,

But from earlier post this is retro active to sept 1, 2006

so if person had anniversary date from 9/1 up to today should show their vacation hours.

so if person was hired on 11/1/1999 their vcation hours should not show up till 11/1 this year

Thanks in advance for the help using win

 

[barry houdini]

Try this formula in F6

=IF(DATE(YEAR(C4)+DATEDIF(C4,DATE(2107,9,1),"y")-100,MONTH(C4),DAY(C4))>TODAY(),"",G3*8)

format F6 as number or general

 

[UPN]

Thanks

Thanks Barry

it seems to be what I needed. Many thanks

Paul