Get instant live Excel expert help with Time and Date Functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How to show value in days that represent duration in pivot chart excel?
Solved by B. F. in 23 mins
Need to get values for the last 7 days, 30 days & 42 days to calculate into a speeometer
Solved by F. A. in 17 mins
How to find the average of something? I need a formula to average the number of days from column H and Column I and column I to J and J to L
Solved by F. Q. in 17 mins
I need to calculate percent selling price and number of days on the market using structured references. When I try using "/" to divide selling price/list price, to calculate percent selling price, it doesn't work.
Solved by K. L. in 16 mins
I've lost an excel 2017 spreadsheet on my mac. I'm not sure it was saved or not, but had been working for several days. I can't find and can't find excel autosave file. I think it's gone for good, but had to ask for help before I start over.
Solved by V. D. in 20 mins
I need a formula to calculate the average between a group of cells however the cells contain the below formula:
=IF(C41="Y",(INT(NETWORKDAYS.INTL(A41, I41, 1,)/5)-1&" Weeks "&MOD(NETWORKDAYS.INTL(A41, I41, 1,),5)&" Days"),(INT(NETWORKDAYS.INTL(A41, I41, 1,)/5)&" Weeks "&MOD(NETWORKDAYS.INTL(A41, I41, 1,),5)&" Days"))
I've tried using the Average formula but responds with #Div/0!
Solved by E. L. in 30 mins
Trouble with calculating "DAYS". Where you would expect the # of days, it still just shows the formula.
Solved by B. Q. in 19 mins
In cell B17, calculate the number of delivery days for the order. Insert an IF function that first tests whether the value in cell B16 is equal to an empty text string (""). If it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range F5:H8 using the value of cell B16 as the lookup value.
Solved by K. B. in 15 mins
In cell K6, enter a formula to determine the total cost of the rental by based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Copy the formula to the range K7:K32. Note the discount applies only to the car rental, not the cost of gas.
Solved by B. L. in 21 mins
I have been working on a spreadsheet for the past few days. This spreadsheet is to be able to calculate items sold, number of items to reorder and what current stock levels are; I am wanting to be able to carry out stock counts on a weekly basis and to be able to auto calculate items sold and what amount to reorder.
Now, I am having issues with the correct formulas to use to do this. It is rather complex so I would be gratefully appreciated for some assistance.
Solved by D. J. in 25 mins