# 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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,033
Messages
5,856,941
Members
431,841
Latest member
jaybeem

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back