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
Formula for: Max number of days for open ticket (data columns equal number days and a column for status (open, closed). Trying to use Max(if) statement
Solved by A. D. in 26 mins
I have to do an employee review project and I'm having trouble with having the upcoming review say "ALERT" if the review is within 6 days and anything 7 days or over to say "pending" and missed reviews to say "Past" with a strikethrough.
Solved by S. Q. in 18 mins
Hi. Been on this problem for days now. Here is the formula I have managed to come up, it works ok and does what I need but I need the D3 and E3 to be referenced in the same way as the FEE_Table as when I . For instance when I select a value from the data validation list in Y2, if the value in AA2 is blank it returns value from Postage!D3, but if not it returns value from Postage!E3. These D3 & E3 values are in the same FEE_Table. So am hoping there is some way I can include in the IF function another Vlookup which chooses the value I want. Any help would be much appreciated. Thanks
=VLOOKUP(Y2,FEE_Table,4,0)+IF(AA2="",Postage!D3,Postage!E3)
Solved by M. A. in 21 mins
If column D is equal to column N, then I need column E to auto populate with the corresponding days in column O.
Solved by O. J. in 28 mins
need to create some logic in my sheet i m trying since past 3 days my friend was also unable to do that help please
Solved by M. H. in 17 mins
On sheet2, I need to create a table that shows me who will be available on specific days i.e. if want to know who is available on Thursday & Saturday and what times they are available and their comments.
Solved by C. C. in 28 mins
Hi I have 200+ shipments listed and my boss wants the percentage of shipments that were shipped in 10-15 days and those >20 days (nothing over 100 days) in a pie chart but I have no clue how to do this
Solved by C. J. in 23 mins
Use an IF formula to display the listed price when the house has been on the market 0-60 days. Within the formula, cause a blank to display if more than 60 days
Solved by E. H. in 20 mins
I need to plot this as a scatter graph. The X axis should be days (1-14) and the Y axis should show bedtime (from 11-2am) on the LHS and sleep onset (30mins-150mins)
Solved by G. U. in 27 mins
I want to know how to only calculate overtime if the employee is listed as "Direct", (ot days x hrs) and not calculate overtime for any employee if not listed as "direct" = 0
Solved by C. U. in 13 mins