Enter a Static Date through a Formula

kldesber

New Member
Joined
Dec 20, 2005
Messages
1
I am trying to create a formula that enters a static date if another cell contains data. I am using an =If function, and do not want to nest the =Now or =Today functions because they automatically update.

I hope someone can help!

Thanks,
Karen
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,118,287
Messages
5,571,318
Members
412,382
Latest member
Langtn02
Top