**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.*