Added: 2 years ago
From: ExcelIsFun
Views: 2,011
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:
see all

All Comments (8)

Sign In or Sign Up now to post a comment!
  • can anyone help? I need a formula that can tell me when a date is over due.or is about to be over due. ... for instance... employee badge expires on 05/01/09... and the present date for that

  • If date is in cell A1, then this formula will tell you if the current date is over the date in cell A1:

    =IF(A1>TODAY(),"Past Due","Not Over Due")

  • You can also watch this video:

    Excel Magic Trick #12: Date Math!

  • i noticed that there were a couple of times when Bill automatically resized the column, without having to double click on the column name at the top of the window. is there a trick to do this?

  • Best fit columns:

    Alt H + O + I

  • Hello, well I got a small question, Where's your email adress again?

    I got a question which i'd like to mail, Thanks in advance, Kind regards

  • search for excelisfun here at YouTube. Then go to the excelisfun channel and use the e-mail link there.

  • YouTube does not allow us to post e-mail or web addresses in comment section.

    Search for "excelisfun", go to the excleisfun YouYube channel, look on the left for the "Send Message" link.

Loading...
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more