First time post and am impressed (and dwarfed) by the knowledge floating around out there. I'm in the right place for this easy question. Would like to be able to have a cell calculate the system date between a range (ie 10/01/02 and 10/31/02) and if the current date falls within that range the cell value would input a number from another cell? After the date range is pasted (ie 11/01/02) the number in the cell would remain as it was on the last day.
I have Simply in cell P27 the formula =SUM(P25:P26) and it equals say 25.
IF today is 10/8/02 then cell O33 would get the number 25 input into it.
A coworkers attempts have brought this formula (that doesn't work):
=IF(TODAY()<DATE(2002,11,1),O33=P27,O33=O33)
_________________
David L. Churchill, MSgt, MNANG
Network Administrator
david.churchill@mndulu.ang.af.mil
Comm: (218) 788-7897
FAX: (218) 788-7457
"Experience... is simply the name we give to our mistakes."
||||| /
/ [_]
(-) (
This message was edited by Juan Pablo G. on 2002-10-09 17:07
I have Simply in cell P27 the formula =SUM(P25:P26) and it equals say 25.
IF today is 10/8/02 then cell O33 would get the number 25 input into it.
A coworkers attempts have brought this formula (that doesn't work):
=IF(TODAY()<DATE(2002,11,1),O33=P27,O33=O33)
_________________
David L. Churchill, MSgt, MNANG
Network Administrator
david.churchill@mndulu.ang.af.mil
Comm: (218) 788-7897
FAX: (218) 788-7457
"Experience... is simply the name we give to our mistakes."
||||| /
/ [_]
(-) (
This message was edited by Juan Pablo G. on 2002-10-09 17:07