Non changing Date or Time in Excel, use the now or today function with out the number changing. Enter a time stamp or a date stamp for when things occur. Allow me teach you the skills in Excel that you need for business
Let me teach you the VBA that I have learn in my five years of consulting
Let’s take the frustration out of user forms
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condenser Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Hey this worked great. in google sheets. Can I insert a drop down calendar. instead of a date ?
I tried this in google sheets and it worked. I want to test for a check box and have a time date stamp. for a rewatch list for a tv series. is there any way to turn off circle references in numbers?
that is what I was looking for . Thanksssssssssss
Is there a way to Make a button to add a row above the first and keep the functionality of the equation
Thank you Ms Barb this is very helpful 🙂
Awesome. I was looking out for this for quite sometime. Really makes life lot easy. Thank you so much!!!!!
The time wont Change from 12:00 AM
it's useful tip, Thank You so much
I typed in exactly like that =if(B2<>"", if(A2="", Now(), A2),"") – it says it's not a correct formula… Telling me I need to put values for true and false, and bringing me to the part where is B2<>"". Like something is missing here.
This formula only work for the backward
I mean if I want time in coloum B and I put data in coloum A
This vid is what I was looking for!!!!! Very useful. Thank you for sharing this method!!!!!
This is exactly the video I needed. Thank you.
Thanks a lot Barb.. helped me solving this issue..
Hi! Great video and formula works well. Only if I try to format my data as a table it stops working for me. The return value is 0 in new lines . Does anybody know if/how I can fix it? I want to make a table so that the formula automatically goes with the cells as the table extends. Thanks in advance
Superb. Great Stuff.
Tx Barb. You have my subscription 🙂
Thank you soo much…
if i put =today() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell
if i put =today() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell
Useful. But… Oops… Doesn't work!
Woowww awesome.. this really helped me in saving a lot of my time.. thank you Barb..
=SI(A1<>"";SI(B1="";HOY();B1);"") en español
Awesome tutorial. I have been needing this for a long time. How would you create a timestamp that changes when a cell is updated? Thank you.
Hi Barb, excellent video, appreciate for sharing. One small request…suppose I use a sum() formula to enter value in B2 and use the same formula in B3, B4…B7, etc., I wish B2 does not update if B3,B4…B7,etc. updates at a later date & time…help please.
Thanku mam Love you mam..
This is what I am looking for…Thanks…
Hi, Is there any way to protect the formula from erase accidently?
Hi to add time difference with this formula?
💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐💐
Hi
Thanks for the video.
I get the following error when i do this: We found a problem with this formula. Try …..
I'm doing exactly what u do in the video… what could be the problem?
Thank you