Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of Months Weeks and Days Between Two Dates
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of Months Weeks and Days Between Two Dates
Check out this link...
http://www.cpearson.com/excel/datedif.htm -- HTH... Jim Thomlinson " 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of Months Weeks and Days Between Two Dates
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of Months Weeks and Days Between Two Dates
Jim, Ron. Thanks for your thoughtful and quick responses. Ron, your
solution works beautifully. I've been trying to get this right forever! Thanks again. Good guys, both of you. ~Rip |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of Months Weeks and Days Between Two Dates
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to calculate the nuber of weeks between dates? | Excel Worksheet Functions | |||
WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES | Excel Worksheet Functions | |||
How to calculate in weeks and days? | Excel Discussion (Misc queries) | |||
A number of days into weeks and days | Excel Worksheet Functions | |||
Calculating number of weeks from two dates | Excel Discussion (Misc queries) |