All solutions COLUMNS Expert Solution – Excel COLUMN Problems

Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc