Hi All!
I'm trying to get a cell to return today's date if another cell has the word "CAR" in it, I have a formula =IF(E4="CAR",TODAY()) but the date has to stay fixed & not change if opened the day after, plus if not TRUE return a blank rather than "FALSE"? Thank you in advance!
If(e4="car",today(),"")
Last edited by Cutter; 08-27-2012 at 09:04 AM. Reason: Removed whole post quote
Hi sunil.excel,
This works great but will change the date if I open it tomorrow, is there a way to date stamp this so it doesn't change once entered? Thanks for your time & greatly appreciated!
Marco
Hi
Take a look at this.
http://www.mcgimpsey.com/excel/timestamp.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks