Get instant live Excel expert help with Time and Date Functions

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.

CONDITIONAL FORMULA FOR LESS THAN 20 WORKING DAYS NOT ELIGIBLE FOR SUNDAYS AND OTHER PUBLIC HOLIDAYS PLEASE LET ME KNOW HO WE MAKE A FORMULA IN EXCEL CAN U HELP ME FOR DOING?

Now use the RANDBETWEEN function in Microsoft Excel to select two simple random samples of 10 days sample and 500 days sample from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [20%].

I have total which calculates the number of a product sent to a location in the last 28 days, but I need a formula on top of this which will also deduct on a weekly basis the weekly average that the location uses of the sent product. So the total should be how many are continuously sent in the last 28 days with the weekly average automatically subtracted every 7 days.

Hello, I need a formula please that changes days. For example Wednesday 11/7/2018, in the next cell Thursday 12/7/2018, the cell next to it changes Friday 13/7/2018. Then when I come in on Monday and Refresh the sheet, it would keep up with the days (Monday would be 16/07/2018) etc.. Is there any formula that can assist?

I need a countif in excel that can help me see how many days an item we have ordered was on site (by serial number) until it was shipped out.

'Display Settings' is showing up on my status bar in excel right before the zoom option. It showed up two days ago and i do not know how to make it disappear

I have a basic spreadsheet with a formula that tells me how many days a specific project has been worked on by all employees. I want to be able to filter this information by individual employee, so for example how many days did employee 5 work on santander, how many days was employee 5 on bench etc?

I need to create a formula that populates a calendar with a color based on certain tasks done on certain days. For example, a certain task might start on a Wednesday, and extends 6 days. I can create that formula, I just would like to exclude the weekend from the count, so in this example Wednesday, Thursday and Friday would be filled, and so would the first three days of the next week starting on Monday.

Hi, I've just created a spreadsheet to keep track of scavenger hunt results. I have 7 columns and 210 rows. What I'm wanting to do is create a drop down arrow on the column header where they can type their name and it will result in bringing up all instances of that name (and all columns/rows that apply. This will allow them to search, and see how many items they have done already and what is still outstanding. They can also check on teammates by entering their name. It's like the name column in the Excel spreadsheet at work used for schedules. I just type my name and all my days and times are there and everyone else's information is gone.