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!
I was previously talking to an expert who was helping me with this file.
I run an Airbnb with a couple units. I need to show which days the units are booked and which days have inquiries on them. I want this to be in a calendar like view
We figured out the booked formula, but the inquiry formula just requires a little tweaking.
Thanks!
Solved by E. A. in 21 mins
I have a spreadsheet that is updated daily with car registrations . Is there a formula that can highlight the same car registrations on each tab when entered on different days automatically ?
Solved by C. C. in 13 mins
I'm stuck with my GANTT chart! I can get the conditional formatting to work for weeks but not for days.
Solved by K. D. in 29 mins
i need help to create a formula where it will highlight or a cell would be alerted to notify that an employee has worked 7 days in a row. We cant have an employee work more than 7 days straight from 1 week to another. The formula needs to go from the previous weeks schedule and into the current weeks schedule then into the next weeks schedule and so on
Solved by G. J. in 24 mins
Good afternoon I need a formula that give me a daily number of days a document is late. so if I checked something today and it was late by 2 days then I check tomorrow I expect it to display 2 days.
please help with a formula
Solved by O. J. in 28 mins
I have a spreadsheet with formulas and also connecting sheets. The last few days the formula boxes will not update automatically when I add information until I double click on the formula cell. this is affecting sheets connected and also the sheet itself.
Solved by T. A. in 19 mins
Hi,
I am currently trying to create a KPI spread sheet for work,
I need to row to show the new average yet to achieve for the remaining days of trade.
Would you know a formulae that I can use to achieve this.
Thanks
Will
Solved by F. E. in 15 mins
Can you help me Identify how many times the names repeated on the other days?
Solved by O. Y. in 15 mins
I have an escalation tracker and I want to create a function the will add the days on the cleansing period base on the escalation serve into the respective employee. can you help me to work on this?
Solved by A. Y. in 23 mins
Could I ask a function that will compute for the cleansing period depending on the escalation serve into the employee, for verbal it should be 30 days, for written it should be 60 then 180 days for final written
Solved by K. C. in 19 mins