Get instant live expert help on I need help with excel days since date
“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
I would like to have a running "days old" cell, after a "date" cell, to show a running days since an event date. This will be different for each row, based on the date entered into a cell.
Solved by B. Q. in 21 mins
Example:
Column E - User inputs date of test
Column H - Indicates number of days since last test (=DATEDIF(E16,I16,"yd")
Column I - Hidden Column with the current days date to give number of days since last test in column H.
What's happening in Column H is that from the value 365, the value in volumn H reverts back to 0 and restarts the count and i need it to continue.
Solved by G. Q. in 17 mins
Hello! I need a formula to calculate the number of days since a date entered but NOT the formula used to calculate the number of days between TWO different dates. Can you help me?
Solved by X. J. in 24 mins
Need a formula to count the # of days since a reported incident
Solved by B. B. in 24 mins
I have a table and need to insert a check or symbol in a column based on a date from column c..
Example...
Data Column A | Data Column B | Date Last used C | >120days D | 90-120 Days E | 60-90 Days F | < 60 Days G
We want to just change the data in columns A, B and C...and have the check mark or * show up automatically in the corresponding time since last used columns based on if it was 120 days or greater from today..
Solved by D. D. in 17 mins