Get instant live Excel expert help with Time and Date Functions

Cell E3 needs to equal - if C3 is "IN" (A3+65 days), if C3 is "OW" (A3+35 days) Does that make sense?

Im looking for a formula I want to start at £40 but after 28 days this should automatically increase to £85 ie 15/03/18 it would be £40.00. But on 12/04/18 it would increase to £85.00

Given 5 different categories, and data spanning 50 days for all 5 categories. I'd like to be able to input which category and the start and end times and be able to automatically output the values at between those times for that specific category.

I cant figure out how to accomplish this...here is the question "Duration is measured in days, but 30-day intervals are more appropriate for most reporting purposes. Using Excel, create a new column titled "Duration_Months" by converting the duration into 30-day intervals" Use data in column H.

2. Now use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population

An expert built a formula for me and it works great. I forgot to request an additional condition. If you look at the formula(Row 6007), we are filtering by cells A, B, C and look at the individual column between W and BG and calculate the sum of O when there is a cell with data. I missed mentioning that we can have more than one cell in a row with data. Only a percentage applies to the quantity. Example: Filter by MEG-40063 Studon 16 F0 Column O and Column Row 1921, same for row 1922: 3 days are required, it will change our planned quantities cell AV1, AW1, AX1 from 3 to 1

I have received a formula from your side as attached in the sheet. I wanted to find out for how many instance a person has worked for more than 6 days straight or 7 days or 9 days. The sheet which I received had the formula, but when I am applying it to another sheet it is not working. Pls help.

I need a formula that allows me to alter a number by using a specific colour, being used on a calendar so when i select the colour for holiday, it changes the remaining days i have left

Private Sub Workbook_Open() Dim wsh As Variant For Each wsh In Worksheets(Array("employee wages", "concrete (hanson)", "accounts & 30 days", "Tables", "cash expense", "master")) wsh.EnableOutlining = True wsh.EnableAutoFilter = True wsh.Protect UserInterFaceOnly:=True, Password:="abc" Next wsh Range("Hidemainsheet").Select Selection.EntireColumn.Hidden = True End Sub

Private Sub Workbook_Open() Dim wsh As Variant For Each wsh In Worksheets(Array("employee wages", "concrete (hanson)", "accounts & 30 days", "Tables", "cash expense", "master")) wsh.EnableOutlining = True wsh.EnableAutoFilter = True wsh.Protect UserInterFaceOnly:=True, Password:="abc" Next wsh Range("Hidemainsheet").Select Selection.EntireColumn.Hidden = True End Sub how do i add ranges hideEXcolumn and hidetable2 to this code? I tried altering code to Range("Hidemainsheet, hideEXcolumn, hidetable2").Select but its not working?