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.

0 votes

Loading... 4,314 views

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

1. simeoda says:

   27/07/2012 at 3:38 am

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

   Reply
2. bord3ful says:

   27/07/2012 at 4:23 am

   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. ?

   Reply
3. nexthacker007 says:

   27/07/2012 at 4:49 am

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

   Reply
4. oki8884 says:

   27/07/2012 at 5:44 am

   Awesome dude! thanx

   Reply
5. ksuzannes1 says:

   27/07/2012 at 5:48 am

   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

   Reply
6. bheemarajuk says:

   27/07/2012 at 6:19 am

   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

   Reply
7. ossman20081 says:

   27/07/2012 at 6:34 am

   thank you so much great job indeed
   

   Reply
8. pinkbambi1020 says:

   27/07/2012 at 6:39 am

   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.

   Reply
9. jerrychi770 says:

   27/07/2012 at 7:18 am

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

   Reply
10. istheemcee says:

    27/07/2012 at 7:51 am

    Excellent! Thanks. Looking forward to your next video.

    Reply
11. Redstarsc2 says:

    27/07/2012 at 8:08 am

    Is the #21 the last chapter?

    Reply
12. Redstarsc2 says:

    27/07/2012 at 8:57 am

    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.

    Reply
13. MotionTraining says:

    27/07/2012 at 9:52 am

    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.

    Reply
14. istheemcee says:

    27/07/2012 at 10:44 am

    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!

    Reply