trigger date

UPN

Board Regular
Joined
May 14, 2006
Messages
138
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 all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Give this a try

=IF(NOW()<39137,"No Formua","Your Formula")

39137 is the decimal representation of Feb 24, 2007.

HTH
Cal
 
Upvote 0
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)
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0
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

thanks in advance
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top