Hi , I want to display the current timestamp for each entry into a column, however when I use =IF(B3 <> "",IF(A3="",NOW(),A3),"") I get 1/0/1900 and even though I changed the format cells option to custom date time , I get the same result. Please help, I want to know what is wrong.
Thanks!
What type of data is in A3 and B3?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It seems to me that the result you get as 1/0/1900 is when A3 cell has 0
Try this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
[QUOTE=AliGW;4541350]What type of data is in A3 and B3?[/QUOTE
A3 is timestamp and B3 is a number
This worked!!!! Please be kind and explain why this works..thanks a million...Originally Posted by AlKey
It seems to me that the result you get as 1/0/1900 is when A3 cell has 0
Try this
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks