Thread
:
Calculate Number of Months Weeks and Days Between Two Dates
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
Posts: 5,651
Calculate Number of Months Weeks and Days Between Two Dates
On 21 Sep 2006 13:04:15 -0700,
wrote:
Greetings:
Here's a problem that I've yet to figure out.
I'm trying to determine the number of months, weeks and days between
two dates to determine what the cost of a rented item will be, when the
vendor offers a discount for monthly rates over weekly rates over daily
rates. The standard pricing is always with the assumption that a month
is thirty (30) days, a week is seven (7) days, and a day is, well a
day...regardless of the actual calendar months they cover.
The desire is to have the answer divided in to three fields. For
instance, a rental for 39 days would ideally return the answer "1
month, 1 week, two days", in unique cells specific to each piece of
data.
Can anyone help with this? Thanks!
Rip
Method 1 (returns the values in separate columns):
A1: Rental Term
B1: Months
C1: Weeks
D1: Days
A2: <enter the number of days of the rental term
B2: =INT(Rental_Term/30)
C2: =INT(MOD(Rental_Term,30)/7)
D2: =MOD(MOD(Rental_Term,30),7)
You can custom format the cells to have the unit of time displayed as you
describe above, if you want.
--ron
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld