View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RedFive RedFive is offline
external usenet poster
 
Posts: 27
Default Don't Update Function

I have a function that automatically puts the date into a cell if other cells
contain information. But I don't want the date to change everytime I open
the spreadsheet. The function I have looks like this:
=IF(b50,today(),"")
How do I get it to only put in today's date, but not put in today's date
everytime I open up the spreadsheet?
--
RedFive