Microsoft Excel Tutorial for Beginners #21 – Date & Time Pt.2 – Date Calculations

Microsoft Excel Tutorial for Beginners #21 - Date & Time Pt.2 - Date Calculations

Visit MotionTraining at www.motiontrainingweb.com Working with dates is essential for many Excel users. In this video learn how to perform basic date calculations. More tutorials soon.
Video Tutorial Rating: 4 / 5

Don’t forget to check out our other video tutorials or share this video with a friend.

1 Star2 Stars3 Stars4 Stars5 Stars 0 votes
Loading... 3,926 views





14 responses to “Microsoft Excel Tutorial for Beginners #21 – Date & Time Pt.2 – Date Calculations”

  1. simeoda says:

    Thank you so much with these videos.It helped me to land a job!

  2. bord3ful says:

    hi is it possible to set up a alerts through condition formating for increments of 5? example: 1,2,3,4,5 Alert. 6,7,8,9,10 Alert. ?

  3. nexthacker007 says:

    i am your new subscriber. just because of your Awesome video tutorials.

  4. oki8884 says:

    Awesome dude! thanx

  5. ksuzannes1 says:

    Thank you so much for taking the time to put up these video out of the goodness of your heart. question at 6.12 in the video you press f4 to give absolute reference to give the days left in the following row. I don’t quite understand why not just copy from the first formula(cell containing 0). I know it does not work but I am bit confused why it does not work and why when you press f4 the currency symbol appear. I don’t remember when you explained absolute reference

  6. bheemarajuk says:

    sir your videos are so good that i learn t a lot from that, thank for you that and sir could you please upload the videos on spss beginners(statistical package for social science) as soon as possible , it will be very helpful for me. Thank you

  7. ossman20081 says:

    thank you so much great job indeed
    

  8. pinkbambi1020 says:

    Thank you so much for all your videos. I got excellent mark from my boos now since i watched your videos. Please feature also pivottable,userform and macro..i watched other’s video but your really different.. thank you.

  9. jerrychi770 says:

    I went through all 21 videos, GREAT JOB!!!

  10. istheemcee says:

    Excellent! Thanks. Looking forward to your next video.

  11. Redstarsc2 says:

    Is the #21 the last chapter?

  12. Redstarsc2 says:

    Thank you so much, I have spent some good time watching your videos and I really
    want to say THANK YOU VERY MUCH. Thanks for spending some time teaching us. I believe you made a huge difference in our lives.
    May you have a happy life.

  13. MotionTraining says:

    Hi. Good question. There are a couple of things you can do. The easy way is to apply a ‘Conditional Format’ to the cell so that any negative value is formatted as white text. A better way would be to combine the date calculation with an IF function to put a message in the cell if the result is negative. For example: =IF(A7-$E$3<0,"Past",A7-$E$3). If you want the cell blank use "" instead of "Past". Hope that helps.

  14. istheemcee says:

    Love the videos! Please Keep it up!
    Quick Q about the dates. When a show date has expired, it will show a minus figure in the “Days to Go” column. Is there a way of just showing nothing rather than a minus figure? It is not a huge issue but just curious.
    Thanks again!

Leave a Reply to oki8884 Cancel reply

Your email address will not be published. Required fields are marked *