Formulas using Dates

[ashley72788]

Hello,
I attached a spreadsheet for everyone to review and am wondering if someone could take a look and help me out.

I am trying to write a formula that will look at the date listed in column "D" and focus just on the DAY, not the month or the year.

The purpose of the formula is to verify that a process was completed in a timely manner.

Column A contains a number, this number is a "rebill" date and the folks in my department must have their rebills approved within 6 days from that date.

Example:

Column A shows a rebill date of "20" and Column D shows a date of 1/27/16, we know that they were completed on time.
Column B shows a rebill date of "10" and Column D shows a date of 1/20/16, we know that they were NOT completed on time.

Is there a way to do this and enter a percentage in a total line based off of that formula? For example, this would be 50% of rebills sent on time.

Thank you!

[Jonmo1]

If the criteria for "on time" is within 6 days of the rebill date
How is the first one on time, when the rebill date is 20 and the date approved is 27 (27-20 = 7) ?

[ashley72788]

Oops, sorry, you can use 7 days instead of 6, my bad

[Jonmo1]

ok, but this still doesn't seem logical to me, considering only the Day part of a date.
What if the rebill date was say 28, and the approved date was 1/2/2016
Is that on time?

anyway, to specifically post a solution to the posed question, you can just use the DAY function

=IF(DAY(D2)-A2<=7,"On Time","Not On Time")

[ashley72788]

I would use a formula to add 7 to the rebill date...so example:

if rebill date is 20, and we need it completed with in 7 days I would start the formula off by putting the rebill date+7 and so on.