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
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?
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
yosoyisrael 2 years ago
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")
ExcelIsFun 2 years ago
You can also watch this video:
Excel Magic Trick #12: Date Math!
ExcelIsFun 2 years ago
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?
indiaujla 2 years ago
Best fit columns:
Alt H + O + I
ExcelIsFun 2 years ago
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
deekaaboy 2 years ago
search for excelisfun here at YouTube. Then go to the excelisfun channel and use the e-mail link there.
ExcelIsFun 2 years ago
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.
ExcelIsFun 2 years ago