An Excel Tutorial for Using the TEXT and the TODAY Functions.

Posted on May 27, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - An Excel Tutorial for Using the TEXT and the TODAY Functions.

It’s the second day of the Excel Tutorial week. Yesterday was Monday and Monday is of course the day that we need to take it a bit slow and we did so with an Excel Tutorial with the formula for checking future dates.

 

Today we are taking it a bit further. It is still kind of a easy Excel formula but it’s too warm you up a bit for later this week, when we are really starting to use Excel for calculating with dates and time spans.

 

But before I begin the actual Excel tutorial I need to explain something that you’ll need to know about Excel for later this week. Microsoft Excel saves a date as a sequential number. Excel has to do that otherwise the program can’t use the value to calculate with. The sequential numbering started on January 1, 1900. So January 1, 1900 has the value 1 and May 27, 2008 has the value 39594 because it’s 39594 days after January 1, 1900.

 

Today I want to show you an Excel tutorial for using the TEXT and the TODAY functions.

 

  • First you’ll need to type the formula =TODAY() in cell B1.

 

Excel-formula-tutorial-pic1

 

  • The project will take you ten days so you’ll need to type in cell B2 the formula =TODAY()+10.

 

Excel-formula-tutorial-pic2

 

  • Now you’ll need to select cell A3 and type the following ="The project starts on "&TEXT(B1;"MM/DD/JJJJ")&" and starts on "&TEXT(B2;"MM/DD/JJJJ") .

 

Excel-formula-tutorial-pic3

 

  • After you pressed enter you’re spreadsheet should look like this.

 

Excel-formula-tutorial-pic4

 

So, that’s it for today. I hope you’ve found this Excel tutorial useful and that you’ve learned a few new things. Now you know how to combine the TEXT and the TODAY function. I’ll see you all the day after tomorrow with the next Excel Tutorial. I have a pretty cool Outlook Tutorial for you tomorrow. Don’t forget its Outlook Wednesday!

 

 

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

5 Responses to “An Excel Tutorial for Using the TEXT and the TODAY Functions.”

  1. Vincent on May 28th, 2008 7:14 pm

    Today I received an e-mail that I made a small copy + paste error in the tutorial. It’s fixed now so enjoy yourself!!

    Again; thank you Mario, appreciate it!

  2. Bobbi on June 5th, 2008 10:08 pm

    Your my new teacher! I’m working on the City Center Project in Las Vegas. I need all the excel skills I can get.

  3. ashu on August 30th, 2008 8:34 pm

    i want to know how to handle long database in ms excel

  4. Vincent on August 31st, 2008 1:40 pm

    I have some articles planned about Excel Databases, hang around. If you want to know something specific contact me via the contact form okay?

  5. Mike on September 25th, 2008 2:02 pm

    You have two start dates and no end date now in the sentence in A3.
    Change the second “starts” to “ends”.

    Good tips otherwise.

Leave a Reply