# trigger date

#### UPN

##### Board Regular
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

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Cbrine

##### Well-known Member
Give this a try

39137 is the decimal representation of Feb 24, 2007.

HTH
Cal

#### UPN

##### Board Regular
thanks

I will give it a try

Thanks again'

#### UPN

##### Board Regular
question

what if i want it to have the contents of a another cell in there
would it be

=IF(NOW()<39137,"No Formula",=L10)

#### james_arackal

##### Board Regular

This will be fine

=IF(NOW()<39137,"No Formula",L10)

#### UPN

##### Board Regular
tested

i tried this using todays date and it put L10 in the cell

if L10 has 20.00 i want it to put 20.00 in the cell f7

#### UPN

##### Board Regular

sorry had quotes around it it works

#### james_arackal

##### Board Regular
You Might have done like this

=IF(NOW()<39137,"No Formula","L10")

Remove the inverts from L10 and type like this

=IF(NOW()<39137,"No Formula",L10)

#### UPN

##### Board Regular
problem

having problem with this becasue of people that will be getting time this year

if a person start date is coming up, it will trigger on that day, but a person day that is passed will not be trigger till the next year

so if person was hired on 2/24/1992, their time wont be given to them till 2/24/07

but a person hire on 11/1/2001 will be given their time this year

I need a formula that will cover bothe these instance in same cell
hope you understand what i am trying to explain

#### UPN

##### Board Regular
need more for this

Company was bought out and new vacation system put in.

Need sort of a two part or maybe 3 part formula.

If person's anniversary date was after 9/1/06 they get the vacation they are entitled to

If person's anniversary date was before sept 1, they will not get it till the next anniversary date, plus I dont want to show anything in F7 or G7 till anniversary date

start date or anniversary date is in C4 in MM/DD/YYYY format
F7 will be were their alloted vacation time will me placed and G7 will be when they must use the vacation by.

right now i am using this formula =IF(NOW()less than Y2,"",L10*8)
Y2 is date in julian form
L10 is the amount of days the peson gets

Here is example for
Joe Black start date is 2/2/4/1992

so F7 would have nothing in it as well as G7, because his start date was before 9/1/06
but when Joe Black date comes around next year F7 would have his alloted time and G7 would be this "BY: 2/24/2008

Joe Smith start date is 9/25/1999
so F7 would have his alloted time in it and G7 would have this "BY: 9/25/2007

Hope you understand what i am trying to do and thanks in advance for any help

Replies
1
Views
245
Replies
8
Views
51
Replies
0
Views
280
Replies
4
Views
51
Replies
1
Views
181