Automatic Date and Time Input

Would like to have computer’s current date and time automatically appear in a spreadsheet, in column A and on the next row, at each instance that a certain spreadsheet is (re)opened, and in the following format:


which will be understood by me as 2019 Feb 19th 1:15 PM.  I will then manually input, into that dated row, my desired data in the cells of columns B, C, D and so on, then save the document and close Excel.  When I next (re)open the spreadsheet (hours or days later), the then current date and time will automatically appear in column A on the next row.  I will eventually graph my data (y axis) against the date/time (x axis), where the data points will be spaced irregularly in the x axis direction according to the date/time when the data was input into the speardsheet.  Using Excel 2013 in Windows 10 Pro.

Though computer and Windows literate, I’m not even an Excel newbie (!), so your response should be step by step and in layman’s terms.  As a retired academic physician who always freely answers friends’ and neighbors’ medical questions in detail, I very much appreciate your time and consideration in responding to me.  Thank you.

By: Dan

47 thoughts on “Automatic Date and Time Input

  1. nike air max 270

    I want to convey my admiration for your generosity giving support to men who need guidance on this theme. Your special commitment to getting the solution along appeared to be quite productive and has in most cases made men and women like me to realize their dreams. Your own valuable hints and tips signifies a whole lot a person like me and substantially more to my office workers. Thank you; from each one of us.

  2. calvin klein outlet

    I as well as my guys were actually following the great tips and tricks from your site and so suddenly got a horrible feeling I had not expressed respect to the web blog owner for those secrets. Those young boys became joyful to read through all of them and already have in fact been loving those things. I appreciate you for indeed being so accommodating and also for making a decision on variety of impressive subject areas most people are really desirous to discover. My very own sincere apologies for not expressing appreciation to earlier.

  3. Raymundo

    Hello! Do you know if they make any plugins to assist with Search Engine Optimization?
    I’m trying to get my blog to rank for some targeted keywords
    but I’m not seeing very good success. If you
    know of any please share. Thanks!

  4. supreme

    Thanks a lot for giving everyone such a spectacular chance to read critical reviews from this blog. It is usually very good and jam-packed with a great time for me personally and my office friends to visit your website no less than thrice every week to read through the newest things you will have. Not to mention, I am just actually astounded concerning the powerful knowledge you give. Some 3 tips in this article are essentially the most suitable I have had.

  5. yeezy

    I’m writing to let you know what a impressive encounter our princess developed browsing your web site. She came to find a wide variety of pieces, which included what it is like to have an incredible helping mood to have many others without difficulty know chosen problematic issues. You actually exceeded visitors’ desires. Thank you for providing those good, trustworthy, educational and as well as cool thoughts on that topic to Emily.

  6. coach outlet

    A lot of thanks for your entire efforts on this site. My mom enjoys getting into investigation and it’s simple to grasp why. All of us notice all regarding the compelling ways you give powerful tricks through this web site and as well as recommend response from visitors on the content then our own princess is in fact learning so much. Have fun with the rest of the new year. You’re the one doing a fantastic job.

  7. Erwin Dutra

    naturally like your web-site however you have to test the spelling on several of your posts. Several of them are rife with spelling issues and I find it very troublesome to tell the reality nevertheless I will surely come again again.

  8. kobe sneakers

    I would like to express appreciation to this writer for rescuing me from this particular predicament. Because of checking through the world-wide-web and coming across suggestions which were not productive, I assumed my life was done. Existing devoid of the solutions to the difficulties you’ve fixed by means of your review is a crucial case, and the kind which may have adversely damaged my entire career if I had not encountered your blog post. Your personal mastery and kindness in taking care of the whole lot was tremendous. I am not sure what I would’ve done if I had not encountered such a solution like this. I am able to now look forward to my future. Thanks very much for the reliable and sensible guide. I will not think twice to suggest your site to any person who should have care on this matter.

  9. michael kors handbags outlet

    I needed to write you this little bit of word just to thank you over again for these precious opinions you’ve documented at this time. It is certainly generous with you to make unreservedly all a lot of people might have marketed for an e-book to earn some dough for themselves, notably considering the fact that you could possibly have done it if you considered necessary. These tips likewise worked like the good way to be certain that some people have a similar desire just as mine to grasp somewhat more with reference to this condition. I’m certain there are a lot more pleasurable periods ahead for individuals that scan your site.

  10. adidas tubular shadow

    I truly wanted to write a small comment to appreciate you for the remarkable hints you are posting at this site. My rather long internet research has at the end been paid with beneficial strategies to go over with my companions. I would state that that most of us site visitors actually are unequivocally fortunate to exist in a good community with so many brilliant individuals with very beneficial tips. I feel pretty blessed to have encountered your website and look forward to tons of more exciting times reading here. Thank you once more for a lot of things.

  11. hermes belt

    I’m commenting to make you know of the exceptional discovery my cousin’s daughter found going through the blog. She even learned lots of details, most notably how it is like to have a wonderful helping mindset to have many more just know specific tortuous subject matter. You actually exceeded our expectations. Many thanks for offering such good, trustworthy, edifying and as well as fun tips about this topic to Mary.

  12. longchamp handbags

    I am commenting to let you understand what a magnificent experience my friend’s girl enjoyed viewing your blog. She even learned a good number of issues, not to mention how it is like to possess an incredible helping heart to let others easily have an understanding of chosen very confusing topics. You truly exceeded readers’ expected results. Thank you for showing those great, dependable, educational and as well as fun thoughts on this topic to Mary.

  13. sling tv

    I know this if off topic but I’m looking into starting my own blog and was wondering what
    all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very internet savvy so I’m not 100% certain.
    Any recommendations or advice would be greatly appreciated.


  14. sling tv

    Howdy very nice website!! Man .. Beautiful ..
    Amazing .. I will bookmark your web site and take the feeds additionally?
    I’m happy to search out a lot of useful info right here in the put up, we
    need develop more strategies on this regard, thank you for sharing.

    . . . . .

  15. sling tv

    You really make it seem so easy with your presentation but I to find this topic to be actually something which I
    believe I would by no means understand. It kind of feels too complicated and extremely extensive for me.
    I am taking a look ahead to your next put up, I’ll try to get the grasp of it!

  16. yeezys

    I’m just writing to make you know of the extraordinary experience my princess experienced reading your site. She noticed too many issues, which included what it’s like to possess an excellent giving character to let the mediocre ones with no trouble grasp specified hard to do issues. You undoubtedly did more than our own desires. I appreciate you for imparting the important, safe, explanatory and as well as easy tips on the topic to Gloria.

  17. ralph lauren uk

    My husband and i ended up being really fulfilled when Peter managed to conclude his research because of the ideas he discovered out of the web site. It is now and again perplexing just to be giving out tips and hints that people might have been trying to sell. And now we know we need the blog owner to appreciate for that. All of the explanations you’ve made, the simple web site menu, the friendships you make it possible to instill – it’s got everything astounding, and it’s really letting our son and the family do think that subject matter is enjoyable, and that is especially fundamental. Thanks for all the pieces!

  18. converse outlet

    A lot of thanks for your entire efforts on this blog. Kim really loves conducting internet research and it is easy to understand why. We notice all concerning the dynamic manner you convey invaluable tricks by means of your website and even increase contribution from other individuals on the situation then our princess is actually becoming educated a great deal. Have fun with the rest of the year. You have been conducting a really good job.


    Hi! I know this is kinda off topic but I was wondering if you knew where I
    could find a captcha plugin for my comment form? I’m using the
    same blog platform as yours and I’m having difficulty finding one?
    Thanks a lot!

  20. sling tv

    Helpful information. Lucky me I found your website accidentally, and I’m shocked
    why this coincidence didn’t happened in advance! I bookmarked it.


    Great goods from you, man. I have understand your stuff previous to and you are just too fantastic.
    I really like what you’ve acquired here, really like what you’re saying
    and the way in which you say it. You make it entertaining and you still care for to keep it sensible.

    I can’t wait to read much more from you. This is actually a terrific site.

  22. nike air max 2017

    I enjoy you because of all your valuable labor on this website. My aunt really loves engaging in research and it’s easy to see why. I notice all concerning the powerful method you produce rewarding guides through your website and as well inspire participation from other ones about this issue so our own girl is studying so much. Take advantage of the remaining portion of the year. You’re doing a first class job.

  23. air max 97

    I definitely wanted to compose a quick comment in order to appreciate you for those remarkable ways you are placing on this site. My time consuming internet search has at the end been paid with pleasant ideas to exchange with my great friends. I ‘d mention that most of us visitors actually are definitely endowed to be in a decent website with very many wonderful people with insightful tricks. I feel very much lucky to have encountered your webpages and look forward to many more pleasurable moments reading here. Thanks once again for all the details.

  24. yeezys

    I want to convey my admiration for your kind-heartedness supporting men and women that should have guidance on your topic. Your personal dedication to getting the solution all around had become wonderfully valuable and has continuously enabled individuals like me to arrive at their targets. Your new important report denotes a lot to me and further more to my fellow workers. With thanks; from each one of us.

  25. supreme hoodie

    My husband and i got really satisfied that John could deal with his homework via the ideas he was given when using the web pages. It’s not at all simplistic to simply possibly be giving for free things many people might have been trying to sell. Therefore we realize we have got the writer to give thanks to because of that. The main illustrations you made, the straightforward site menu, the friendships your site give support to instill – it’s got many astonishing, and it is helping our son and us feel that that matter is entertaining, and that is wonderfully essential. Many thanks for the whole lot!

  26. coconut oil

    Nice post. I used to be checking continuously this blog
    and I’m inspired! Very useful information specially the remaining phase 🙂 I deal with such info
    much. I used to be looking for this certain information for
    a very long time. Thanks and good luck.

  27. Miesha Wreyford

    This is the right blog for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want?HaHa). You definitely put a new spin on a topic thats been written about for years. Great stuff, just great!

  28. quest bars cheap coupon twitter

    You’re so cool! I don’t believe I’ve truly read something like that before.
    So good to find somebody with genuine thoughts on this issue.
    Seriously.. thanks for starting this up. This site is one thing that is required on the
    web, someone with some originality!

  29. ultra boost 3.0

    I抎 need to check with you here. Which is not one thing I normally do! I take pleasure in studying a submit that may make people think. Additionally, thanks for allowing me to remark!

  30. kd shoes

    This is the correct blog for anybody who needs to search out out about this topic. You notice a lot its virtually onerous to argue with you (not that I truly would want匟aHa). You undoubtedly put a new spin on a subject thats been written about for years. Great stuff, simply great!

  31. adidas nmd r1

    Youre so cool! I dont suppose Ive learn anything like this before. So nice to search out any individual with some authentic thoughts on this subject. realy thanks for beginning this up. this website is something that is needed on the web, somebody with somewhat originality. useful job for bringing something new to the internet!

Comments are closed.