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
 

Some videos you may like

Excel Facts

Add Bullets to Range
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
Joined
Dec 2, 2003
Messages
3,196
Give this a try

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

39137 is the decimal representation of Feb 24, 2007.

HTH
Cal
 

UPN

Board Regular
Joined
May 14, 2006
Messages
138
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
Joined
Aug 17, 2003
Messages
148

ADVERTISEMENT

This will be fine

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

UPN

Board Regular
Joined
May 14, 2006
Messages
138
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
Joined
May 14, 2006
Messages
138

ADVERTISEMENT

sorry had quotes around it it works
 

james_arackal

Board Regular
Joined
Aug 17, 2003
Messages
148
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
Joined
May 14, 2006
Messages
138
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
 

UPN

Board Regular
Joined
May 14, 2006
Messages
138
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,389
Messages
5,547,670
Members
410,805
Latest member
Ginoji
Top