Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates
Good afternoon
i am really need your help. i have got invoices here to work with and i need to find out how it was calculated. company charges me £70p/w hire from 01/01/06 to 31/01/06 and amount is £303.33. how would i set formula to calculate how many days are in a sertain period of time and how many days if week is not complete? Thank you very much Svetlana |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates
To calculate the number of days between two periods, use the DATEDIF
function. See here for more info: http://www.cpearson.com/excel/datedif.htm Dave -- Brevity is the soul of wit. "Svetlana" wrote: Good afternoon i am really need your help. i have got invoices here to work with and i need to find out how it was calculated. company charges me £70p/w hire from 01/01/06 to 31/01/06 and amount is £303.33. how would i set formula to calculate how many days are in a sertain period of time and how many days if week is not complete? Thank you very much Svetlana |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates
Hi Svetlana
I think you might be better off working in days, rather than trying to calculate weeks and days and then using fractions of weeks. To calculate the interval between 2 date, take the earliest date away from the latest date and add 1 (if you want to include the whole of the start date and the whole of the end date) With start date in A1, End Date in B1 enter in C1 =B1-A1+1 which would give 31 days If they are charging £70 per week, it sounds as though they are basing it on a 7 day week at £10 per day. In which case, they charged you for 30.33 days out of the 31 days in the period concerned. If the basis of charging is Working days (5?) then if you have the Analysis Toolpak loaded ToolsAddinstick Analysis Toolpak Then you can use the NETWORKDAYS() function. In this case you need to use the startdate first, THEN the end date. =(Startdate,Enddate,Holidays) =NETWORKDAYS(A1,B1,holidays) where holidays is a named range containing the list of public holidays or =NETWORKDAYS(A1,B1,$C$1:$C$9) where $C$1:$C$9 is the range of cells where you have entered public holidays. Note you don't have to include holidays in the formula at all if you don't want to. -- Regards Roger Govier "Svetlana" wrote in message ... Good afternoon i am really need your help. i have got invoices here to work with and i need to find out how it was calculated. company charges me £70p/w hire from 01/01/06 to 31/01/06 and amount is £303.33. how would i set formula to calculate how many days are in a sertain period of time and how many days if week is not complete? Thank you very much Svetlana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |