View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Using DATEDIF how do I add another month of each date fall on same

Try

=MAX(1,DATEDIF(C6,C5,"m"))

Mike

"kmt1984" wrote:

I am using the following

=DATEDIF(C6,C5,"m")

If I enter the exact same dates the answer is obviously 0, but I want it to
be 1. I only want to add 1 if the dates are exactly the same.

In case it helps I am trying to figure out how far behind an account is, and
if the dates are the same a payment was not made and one more payment would
be due.

Any help would be great!