Creating a Date Count Formula

[tdsmith14]

I am trying to figure a formula that will calculate a turn around or total number of days it takes to completre a process.

For example, with the attached file I want to place formula's in column K (Titled: Turn Around Time) that will calculate from the total number of days it took from the time an invoice was submitted to Acctg to the date a check was issued (Check Date).


Thanks.

[sktneer]

Try this.......

Please Login or Register  to view this content.

[CRIMEDOG]

=(Month(A2)-Month(A1))+((Year(A2)-Year(A1))*12)
A2 is the second date A1 is the first date

[tdsmith14]

No it didn't work it only gave me a result of 1/6/1900

[tdsmith14]

I'm not sure that I understand the second formula you submitted. Are you able to do one in the attachment so I can see?

[kspeese]

Try this: =DATEDIF(A1,A2,"D")+1

A1 = your start date, A2 your end.

[sktneer]

No it didn't work it only gave me a result of 1/6/1900

Change the format of col. K to General which is right now is a date format.

See the attached sheet.

[tdsmith14]

Understood. Thanks a bunch :-)

[sktneer]

Glad to help you. Thanks for the feedback and Rep.