Feb 10 2022 11:50 AM
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.
Feb 10 2022 11:57 AM