Rounding up number that is result of a 360date calculation

Copper Contributor

I created a cell formula to calculate the number of months between 2 dates.

Date 1 - Date 2 = # of days / by 30 = # of months  

 

I have the date cells set to date. 

I have the final result cell set to number.

 

What I need to do, is round up the result, but I cannot figure out how to use the =c1/d1 I have seen in the other discussions.    

Today's Date:3/16/2022    
End  Date: 7/28/2022

 

 

  
Number of Months:

My result cell formula is: =DAYS360(B1,B2)/30

4.40 is the answer. 

 

 

  

I need to set this cell to round up to the next whole number.

 

Not sure where or how to add the quotient that I have seen:  "QUOTIENT =C1/D1"

 

do I make the result go to a non-visible cell? then add the Quotient to the final cell?  

and I'm really unclear how a quotient is supposed to replace ROUNDUP

 

Your help is appreciated.

1 Reply

@tander21022 That would be 

=ROUNDUP(DAYS360(B1,B2)/30,0)

This returns 5.