Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate the number of days between two dates on a 30 day
I want to be able to calculate the days between two "dates" however I need it
on a 30 day system. It doesn't run on a true calendar, but always on 30 days. So essentially between two 1-30 sets I need the amount. I want to include the first number. So if I put down in the first cell "23" and the second cell say "8" I need the total to be 16 Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate the number of days between two dates on a 30 day
Not sure of your requirement
but if first number is in A1 and second in B1 (with A1 always higher than B1) Use this in C1 =A1-B1+1 ------------------------------------- Pl. click ''Yes'' if this was helpful... "James Dasher" wrote: I want to be able to calculate the days between two "dates" however I need it on a 30 day system. It doesn't run on a true calendar, but always on 30 days. So essentially between two 1-30 sets I need the amount. I want to include the first number. So if I put down in the first cell "23" and the second cell say "8" I need the total to be 16 Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate the number of days between two dates on a 30
I'm not sure how that would work? I basically need to know how many days are
in a date range so the 13th-30th is an easy example. It's always on a 30 day period. I would use it to calculate a "prorated" cost so if a person's billing date is the 30th and they change something on the 13th I would need to know the amount of days between the 13th and the 30th (including the 13th). So to use my example from earlier if the individuals billing date is the 8th and they change something on the 23rd of the month before I want the sheet to tell me that there is 16 days in between (that includes the 23rd). While I've seen this one: =IF(B7A7,DATEDIF(A7,B7,"d"),DATEDIF(B7,A7,"d")) That uses a normal calendar to do the calculations (30, 31, etc. months) and I need it calculated on a 30 day basis always. Thanks for the help, but I'm still stuck. "Sheeloo" wrote: Not sure of your requirement but if first number is in A1 and second in B1 (with A1 always higher than B1) Use this in C1 =A1-B1+1 ------------------------------------- Pl. click ''Yes'' if this was helpful... "James Dasher" wrote: I want to be able to calculate the days between two "dates" however I need it on a 30 day system. It doesn't run on a true calendar, but always on 30 days. So essentially between two 1-30 sets I need the amount. I want to include the first number. So if I put down in the first cell "23" and the second cell say "8" I need the total to be 16 Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate the number of days between two dates on a 30 day
James,
=(YEAR(A2)-YEAR(A1))*360 +(MONTH(A2)-MONTH(A1))*30 + DAY(A2)-DAY(A1) HTH, Bernie MS Excel MVP "James Dasher" <James wrote in message ... I want to be able to calculate the days between two "dates" however I need it on a 30 day system. It doesn't run on a true calendar, but always on 30 days. So essentially between two 1-30 sets I need the amount. I want to include the first number. So if I put down in the first cell "23" and the second cell say "8" I need the total to be 16 Any suggestions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate the number of days between two dates on a 30
Use =DAYS360(A1,B1) + 1 with start date in A1 and end date in B1 Days360 assumes that all months have 30 days... ------------------------------------- Pl. click ''Yes'' if this was helpful... "James Dasher" wrote: I'm not sure how that would work? I basically need to know how many days are in a date range so the 13th-30th is an easy example. It's always on a 30 day period. I would use it to calculate a "prorated" cost so if a person's billing date is the 30th and they change something on the 13th I would need to know the amount of days between the 13th and the 30th (including the 13th). So to use my example from earlier if the individuals billing date is the 8th and they change something on the 23rd of the month before I want the sheet to tell me that there is 16 days in between (that includes the 23rd). While I've seen this one: =IF(B7A7,DATEDIF(A7,B7,"d"),DATEDIF(B7,A7,"d")) That uses a normal calendar to do the calculations (30, 31, etc. months) and I need it calculated on a 30 day basis always. Thanks for the help, but I'm still stuck. "Sheeloo" wrote: Not sure of your requirement but if first number is in A1 and second in B1 (with A1 always higher than B1) Use this in C1 =A1-B1+1 ------------------------------------- Pl. click ''Yes'' if this was helpful... "James Dasher" wrote: I want to be able to calculate the days between two "dates" however I need it on a 30 day system. It doesn't run on a true calendar, but always on 30 days. So essentially between two 1-30 sets I need the amount. I want to include the first number. So if I put down in the first cell "23" and the second cell say "8" I need the total to be 16 Any suggestions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate the number of days between two dates on a 30 day
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i calculate the number of days between two dates? | Excel Worksheet Functions | |||
How to calculate the number of days between two dates | Excel Discussion (Misc queries) | |||
Using an Array to calculate the number of days between dates and.. | Excel Worksheet Functions | |||
calculate number of days btw dates | Excel Worksheet Functions | |||
Formula to calculate number of days between Dates | Excel Worksheet Functions |