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

Don't Update Function
 

Look he

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"RedFive" wrote in message ...
|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