View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default rounding a month upwards , after using an =datedif fomula

Maybe

=MAX(1,DATEDIF(A1,B1,"m"))

Mike

"spudsnruf" wrote:

I use formula to calculate numbe rof elapsed months between 2 dates..

=datedif(a1,b1,"m")....

but then want to round up to 1 month, in case the time elapsed is actually
less than 1 month within the =dated calcs.

Anyhelp please?

Thank you.