Rounding up number that is result of a 360date calculation

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3151540%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERounding%20up%20number%20that%20is%20result%20of%20a%20360date%20calculation%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3151540%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20created%20a%20cell%20formula%20to%20calculate%20the%20number%20of%20months%20between%202%20dates.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EDate%201%20-%20Date%202%20%3D%20%23%20of%20days%20%2F%20by%2030%20%3D%20%23%20of%20months%26nbsp%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20the%20date%20cells%20set%20to%20date.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20the%20final%20result%20cell%20set%20to%20number.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20to%20do%2C%20is%20round%20up%20the%20result%2C%20but%20I%20cannot%20figure%20out%20how%20to%20use%20the%20%3Dc1%2Fd1%20I%20have%20seen%20in%20the%20other%20discussions.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3CTABLE%20width%3D%22%5C%26quot%3B200%5C%26quot%3B%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B61.1625px%5C%26quot%3B%22%3EToday's%20Date%3A%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B88.2375px%5C%26quot%3B%22%3E3%2F16%2F2022%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B61.1625px%5C%26quot%3B%22%3EEnd%26nbsp%3B%20Date%3A%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B88.2375px%5C%26quot%3B%22%3E%26nbsp%3B7%2F28%2F2022%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%20width%3D%22%5C%26quot%3B40px%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Months%3A%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%3E%3CP%3E%3CFONT%20size%3D%22%5C%26quot%3B2%5C%26quot%3B%22%3EMy%20result%20cell%20formula%20is%3A%26lt%3B%5C%2FFONT%26gt%3B%20%3CFONT%20color%3D%22%5C%26quot%3B%232356EF%5C%26quot%3B%22%3E%3DDAYS360(B1%2CB2)%2F30%26lt%3B%5C%2FFONT%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%5C%26quot%3B%23DF0000%5C%26quot%3B%22%3E4.40%20is%20the%20answer.%26nbsp%3B%26lt%3B%5C%2FFONT%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%26lt%3B%5C%2FTBODY%26gt%3B%26lt%3B%5C%2FTABLE%26gt%3B%3CP%3EI%20need%20to%20set%20this%20cell%20to%20round%20up%20to%20the%20next%20whole%20number.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ENot%20sure%20where%20or%20how%20to%20add%20the%20quotient%20that%20I%20have%20seen%3A%26nbsp%3B%20%22QUOTIENT%20%3DC1%2FD1%22%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Edo%20I%20make%20the%20result%20go%20to%20a%20non-visible%20cell%3F%20then%20add%20the%20Quotient%20to%20the%20final%20cell%3F%26nbsp%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Eand%20I'm%20really%20unclear%20how%20a%20quotient%20is%20supposed%20to%20replace%20ROUNDUP%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20appreciated.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3151540%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3ETraining%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3151540%22%20slang%3D%22en-US%22%3ERounding%20up%20number%20that%20is%20result%20of%20a%20360date%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3151540%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20cell%20formula%20to%20calculate%20the%20number%20of%20months%20between%202%20dates.%3C%2FP%3E%3CP%3EDate%201%20-%20Date%202%20%3D%20%23%20of%20days%20%2F%20by%2030%20%3D%20%23%20of%20months%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20date%20cells%20set%20to%20date.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20final%20result%20cell%20set%20to%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20to%20do%2C%20is%20round%20up%20the%20result%2C%20but%20I%20cannot%20figure%20out%20how%20to%20use%20the%20%3Dc1%2Fd1%20I%20have%20seen%20in%20the%20other%20discussions.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22200%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2261.1625px%22%3EToday's%20Date%3A%3C%2FTD%3E%3CTD%20width%3D%2288.2375px%22%3E3%2F16%2F2022%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2261.1625px%22%3EEnd%26nbsp%3B%20Date%3A%3C%2FTD%3E%3CTD%20width%3D%2288.2375px%22%3E%26nbsp%3B7%2F28%2F2022%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Months%3A%3C%2FTD%3E%3CTD%3E%3CP%3E%3CFONT%20size%3D%222%22%3EMy%20result%20cell%20formula%20is%3A%3C%2FFONT%3E%20%3CFONT%20color%3D%22%232356EF%22%3E%3DDAYS360(B1%2CB2)%2F30%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23DF0000%22%3E4.40%20is%20the%20answer.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EI%20need%20to%20set%20this%20cell%20to%20round%20up%20to%20the%20next%20whole%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20where%20or%20how%20to%20add%20the%20quotient%20that%20I%20have%20seen%3A%26nbsp%3B%20%22QUOTIENT%20%3DC1%2FD1%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edo%20I%20make%20the%20result%20go%20to%20a%20non-visible%20cell%3F%20then%20add%20the%20Quotient%20to%20the%20final%20cell%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I'm%20really%20unclear%20how%20a%20quotient%20is%20supposed%20to%20replace%20ROUNDUP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3151540%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.