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
Hi there! I'm trying to find the 'Age in Days' for each 'Enterprise Partner' on the 'Find Age' Days tab from the data in the 'Data' tab. I believe you can use a COUNT function, but I'm not sure I'm using it properly. Please provide an example of count function in excel for me to follow
Solved by A. W. in 16 mins
4. In Column E, enter a formula using a nested IF function to determine the number of vacation days based on the rules below:
15 days for full-time employees
10 days for part-time employees
0 days for everyone else
Solved by I. H. in 14 mins
i need to show how if we have 6 staff and each do 150 units a days (5 days a week) how long it will take to complete 92000 units
Solved by K. J. in 25 mins
I have a column for (A) work days / (B) Accumulative target / (C) accumulative sales / (D) achievement - Then i have the following rows: starts at row (5) with the above data. I seem to have everything working except for the achievement column which isn't accumulating the balance correctly, the formula I've created works in the 1st row and shows the correct "Balance" figure, however the next row doesn't show the correct Achievement value because it hasn't taken into account the accumulative target. I can sh
Solved by F. A. in 20 mins
I need a formula in 2 columns to count days out If submitted on May 15 and required to have it back in 21 days. I want column 3 tell me how many days left of the 21
Solved by D. J. in 23 mins
I need to calculate incentives based on both position and working days.
Solved by Z. S. in 21 mins
I am trying to change multiple cells to a certain colour if one cell within this contains the text "days" from a drop down menu
Can you please help ?
Solved by S. H. in 16 mins
i would like to calculate annual leave entitlement and have a tally of how many days they are entitled to and how many days they have taken and what days they have left.
Solved by V. C. in 15 mins
hi, i started getting an error since the last two days, while trying to save my excel files. I get a message saying something like i cannot save because I may have a sharing violation. When I try to save the file, it create a temp file in the same folder with the original file and then does not let me save my changes to the original file. Can you help with this issue? Are you familiar with this issue?
Solved by X. Q. in 22 mins
i need to summarise the hrs worked over multiple days for staff in the shifts page
Solved by Z. H. in 22 mins