How do I do an excel forumala when I have two dates...one is the due date, and the other is the actual submittal date and I have to show how many days it was late based on the due date? Any idea? Is there a formula that will do this or do I have to do it in my head?
2007-12-17 07:19:26 · 6 answers · asked by Anonymous in Computers & Internet ➔ Software
You should use the DATEDIF function.
If date 1 is in A2 and date 2 is in B2; put this in C2.
=DATEDIF(A2,B2,"d")
Remember to format C2 as a number.
2007-12-17 07:25:53 · answer #1 · answered by Samuel Adams 7 · 1⤊ 0⤋
Make sure the due date and submitted date cells are formatted for dates.
In the third cell, use something such as "=c2-b2". Basically subtract the later date from the earlier date. Format this cell as a number. Otherwise 1 day ends up as "1-Jan" or similar.
Good luck!
2007-12-17 07:27:08 · answer #2 · answered by Thomas K 4 · 1⤊ 0⤋
Yes, write your formulas using the standard math but use the dates. Excell will automaticly convert to the serial date and perform the calculations for you....
2007-12-17 07:26:11 · answer #3 · answered by newton3010 6 · 0⤊ 0⤋
The formula for C1: =A1+B1 If it does not show up correctly, make sure that C1 is formatted as a date.
2016-05-24 09:28:20 · answer #4 · answered by desirae 3 · 0⤊ 0⤋
For simplicity, Thomas K "is right on the nose"
Good answer/solution
2007-12-17 07:31:54 · answer #5 · answered by Paul G 3 · 0⤊ 0⤋
An alternative, if you have the Analysis ToolPak installed, you can use the NETWORKDAYS function, which would be NETWORKDAYS(start_date,end_date)
2007-12-20 23:25:52 · answer #6 · answered by HazMat 4 · 0⤊ 0⤋