Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Date Number Format (Serial Numbers)
2. Date Math
3. Formula for Days Invoice Past Due
4. Formula for Loan Maturity Date
5. Formula for Length in Days for Project

Category:

Education

Tags:

• Office
• 2010
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Busn
• 216
• Computer
• Applications
• Class
• Excel
• Date
• Number
• Format
• (Serial
• Numbers)
• Math
• Days
• Invoice
• Past
• Due
• Loan
• Maturity
• Length
• in
• for
• Project

[ExcelIsFun]

I am glad that the videos helped!

[t1ghe]

Just watched a video on time and date formats. it helped a lot with my invoice. thanks very much and keep up the good work. you saved me hours of headache hahaha.

[ExcelIsFun]

You are welcome for the videos!

I am not sure how to solve your "international settings the date format sometimes seems to change " problem. THE best Excel question site is:

mrexcel[dot]com/forum

[FrankRebers]

@ExcelIsFun I know the underlying number is the same but have found that depending on the international settings the date format sometimes seems to change although I try to fix the formatting in the cells. haven't found teh cause of that yet. Then users think they enter in EU format but the cells got formatted to US format, then the underlying number changes. And my compliments to your vids, I used a lot of them to simplify my excel tools and give them more power! Thanks!!

[ExcelIsFun]

It should never be a problem because the underlying number is a serial number that tells us the number of days since Dec 31, 1899. The number under 1-12-2011 on US computers and 12-1-2011 on computers that put the day before the month are the same. So the issue is that you must know what default settings are being used on the computer you are using. These can be changes in the Control Panel under Regional and Language settings.

Let me know if that helps.

[FrankRebers]

I use these type of formulas a lot, but there is one issue and that is the date format itself. In europe we use the dd-mm-yyyy format, in US mm-dd-yyyy is used. Even fixing the format for the cells still creates issues because also the international setting of Windows is a factor, I have not been able to control this yet. Do you have any tips to check or correct date-format so that the formulas work okay, its is a big difference if 1-12-2011 means Jan. 12 or Dec. 1 :-) Hope you can help me here.