Don't Update Function

R

RedFive

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(b5>0,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?
 
N

Niek Otten

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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(b5>0,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to calculate hrs flown in last one year 0
update date 2
Number of Months Between Two Dates Entered 13
Shift - Alt - D shortcut 3
today's date static 1
Date Range Changing Each Time Worksheet Is Opened 2
I am trying to use the IF and SUMIF function on Excel 8
Excel Getting an annualized figure based on YTD in Excel 1

Top