Thread: help with macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hannatrip hannatrip is offline
external usenet poster
 
Posts: 25
Default help with macro

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??