Adding vacation to worksheet cell automatically

Mar 8th, 2002, 11:20 AM

I am trying to make excel 2000 add vacation time at the beggining of the month automatically, at the 1st day of the month, but not until the correct date occurs. Is it possible?

Paul B · Mar 8th, 2002, 12:39 PM

try =IF(TODAY()>=G5,14,"") where G5 is the date to add the time and 14 would be the hours added. HTH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 11:20 AM	#1
Guest Posts: n/a	I am trying to make excel 2000 add vacation time at the beggining of the month automatically, at the 1st day of the month, but not until the correct date occurs. Is it possible?

Mar 8th, 2002, 12:39 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	try =IF(TODAY()>=G5,14,"") where G5 is the date to add the time and 14 would be the hours added. HTH