An Excel Tutorial with a Formula for Checking Future Dates.

Posted on May 26, 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 with a Formula for Checking Future Dates.

Hi folks, I hope you all had a great weekend!! It’s Monday again and it’s the last week of the month and we are having another Microsoft Excel Tutorial week. And I got some great Excel Tutorials lined up for you this week. We covered in the last Excel Tutorial week several Excel Tutorials that had to do with currencies. The last Tutorial we’ve covered that week was a tutorial with a Formula for Calculating the End Date of a Project and we are continuing on this road. This week is going to be about date and time functions in Excel.

 

We are starting the week with an Excel Formula for checking future dates.

 

Let’s say you have a large spreadsheet with a column full of different dates. Say that you want to know how many dates there are in the future. Of course you can count it row by row but it’s much easier to have Excel count it for you. We do that by using the TODAY function and here’s how.

 

An Excel Tutorial with a Formula for checking future dates.

 

Okay, this is the spreadsheet.

 

Excel-formula-tutorial-pic1

 

  • Now select Cell B2:B7
  • And type the formula =IF(A2<=TODAY();"n";"y")

 

Excel-formula-tutorial-pic2

 

  • Then press CTRL+ENTER

 

And you’re done

 

Excel-formula-tutorial-pic3

 

I hope you’ve found this Excel Tutorial useful. Have a great day and I’ll see you tomorrow with another Excel Tutorial.

 

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

Leave a Reply