I got it to work with no changes. Before putting the formula into worksheet
make sure C3 is empty. Highlight the cell where you want the formula and
then paste the forula at the top of the worksheet in the fx box (formmula
box). It shuold work.

"hannatrip" wrote:

I would like to make a macro with the following formula
=IF(C3="","",((40-((C3-(TODAY())))/7)))
it needs to calculate a gestational age when the due date is put in from L5
to L169..

I cant seem to get it to lock so the formula doesnt get deleted so I thought
a macro would work??