Calculating the number of months to charge given the number of days. assuming that up to and including 30 days equals 1 month, and 32 days equals 2 months. a rounding function should be included
cell D1 is where the days are and cell E1 is where the formula needs to be written
thanks
Maybe:
In E1
And - welcome to the Forum!
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
If 30=1 and 31=2 try this...
=CEILING(D1/30,1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Biff,
One (this one at least) wonders why that function was written when good old Int had it covered - care to enlighten me??
The OP said this:
So, if D1=30 then E1 should =1.assuming that up to and including 30 days equals 1 month
Your formula will return 2.
Wow, it just goes to show, there was a reason for the Ceiling function
Duhhhhhhhhhhhhhh
Useless functions:
Excel 2013
=DAYS(end_date,start_date)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks