Question description:
This user has given permission to use the problem statement for this
blog.
I need to count number of dates from a timestamped date in column from the completed date column to show the number of days. I have not successfully been able to do this. I am a novice Excel user. Can you help?
Solved by O. B. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/09/2017 - 04:59
Hi, It's my pleasure to assist you today
User
08/09/2017 - 04:59
Yes i meant # of days not dates
Excelchat Expert
08/09/2017 - 04:59
Entering Explanation phase
Excelchat Expert
08/09/2017 - 04:59
Please provide me the sample in preview
User
08/09/2017 - 05:01
I want C to show # of days between the start and end
Excelchat Expert
08/09/2017 - 05:01
Sure. i am working on it
User
08/09/2017 - 05:01
and how do I make it apply to the entire column?
Excelchat Expert
08/09/2017 - 05:01
You are working on column C?
Excelchat Expert
08/09/2017 - 05:01
Can you please deselect it
Excelchat Expert
08/09/2017 - 05:02
ok. Thank you
Excelchat Expert
08/09/2017 - 05:02
=DATEDIF(A1,B1,"d")
Excelchat Expert
08/09/2017 - 05:02
Here is the formula for number of days
Excelchat Expert
08/09/2017 - 05:02
Entering Discussion phase
Excelchat Expert
08/09/2017 - 05:03
copy the cell and paste downwards to apply for entire column till where the rows have data
User
08/09/2017 - 05:03
I get #VALUE! error
Excelchat Expert
08/09/2017 - 05:04
can you please check in the preview. I get 12 days.
Excelchat Expert
08/09/2017 - 05:04
Please copy the cells from A to C
Excelchat Expert
08/09/2017 - 05:04
or download this file
User
08/09/2017 - 05:06
Thank you - On my live Excel doc I'm still getting the error. Maybe because the first line doesn't have a completion date?
User
08/09/2017 - 05:06
I tried it on a line that does and it doesn't work.
Excelchat Expert
08/09/2017 - 05:06
Ok. That is great
User
08/09/2017 - 05:06
I'll try your file.
Excelchat Expert
08/09/2017 - 05:07
I can suggest one more thing
User
08/09/2017 - 05:07
please :)
Excelchat Expert
08/09/2017 - 05:07
There is an option to avoid that error using iferror statement to make it blank
Excelchat Expert
08/09/2017 - 05:07
=iferror(DATEDIF(A1,B1,"d"),"")
Excelchat Expert
08/09/2017 - 05:07
Try this
Excelchat Expert
08/09/2017 - 05:08
This will show blank when there is an error.
User
08/09/2017 - 05:09
Ok that worked on first line. It put TRUE in the line with an end date.
User
08/09/2017 - 05:09
I still don't seem to have it right how to make the formula apply to the whole column.
Excelchat Expert
08/09/2017 - 05:10
copy the cell with formula and drag down or paste in other cells
User
08/09/2017 - 05:11
I got it!! Thank you!
Excelchat Expert
08/09/2017 - 05:11
Ok. I would like to get opinion on the following
User
08/09/2017 - 05:11
ok
Excelchat Expert
08/09/2017 - 05:11
Have you heard of the new subscription version of Excel? You can keep using your existing computer/laptop and get latest features automatically like online file sharing, and even a browser version of Excel that work with your files. I like it.
User
08/09/2017 - 05:11
no and I would like this on my personal computer. I'm at work now.
Excelchat Expert
08/09/2017 - 05:12
You should try it. It doesn’t cost much. It’s called Office 365 Business.
User
08/09/2017 - 05:12
ok and how much does it cost?
Excelchat Expert
08/09/2017 - 05:12
Any reason why not? We’re not selling it. Just curious.
Excelchat Expert
08/09/2017 - 05:12
If you’re a small organization, about 8 bucks a month! There’s a free trial too.
Excelchat Expert
08/09/2017 - 05:12
If you’re interested, let me know and I’ll tell me manager to add helping you upgrade as a service to our website.
User
08/09/2017 - 05:12
I'm an individual trying to learn for my job. I want to improve my skills.
Excelchat Expert
08/09/2017 - 05:13
That is great to hear.
Excelchat Expert
08/09/2017 - 05:13
My manager will be in touch. Thanks
Excelchat Expert
08/09/2017 - 05:13
Have a great day ahead
User
08/09/2017 - 05:13
how do I sign up? I already submitted my personal email
User
08/09/2017 - 05:13
Thanks
User
08/09/2017 - 05:13
you too
Excelchat Expert
08/09/2017 - 05:13
Please end the session and leave a great review
User
08/09/2017 - 05:14
Ok I will - will it prompt me to leave a review?
Excelchat Expert
08/09/2017 - 05:14
Yes. It asks for rating.
User
08/09/2017 - 05:14
ok
Excelchat Expert
08/09/2017 - 05:14
Once you end the session
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
