Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi there. I need a column to automatically calculate the numbers of days from a start time to today's date.
Solved by T. F. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 03/06/2018 - 05:21
Excelchat Expert 03/06/2018 - 05:21
Hi! How are you?
User 03/06/2018 - 05:21
Good thank you. How are you?
Excelchat Expert 03/06/2018 - 05:21
I'm good, thanks for asking. :)
Excelchat Expert 03/06/2018 - 05:22
To confirm my understanding - you need to calculate for difference of an identified date to today's date expressed in "days". Is this correct?
User 03/06/2018 - 05:22
User 03/06/2018 - 05:23
but i would also like to know how long the match length is in years
Excelchat Expert 03/06/2018 - 05:24
Sure. Could you see the updated columns (C and D) on the document preview?
User 03/06/2018 - 05:25
yes this is how I would like it to look. Could you please give me a step by step guide on how to do this?
Excelchat Expert 03/06/2018 - 05:25
Excelchat Expert 03/06/2018 - 05:25
one moment please
User 03/06/2018 - 05:25
Excelchat Expert 03/06/2018 - 05:27
So in cell C2, which is the adjacent cell to the first date in column B (10/22/14) - you enter the formula =DATEDIF(B2,TODAY(),"Y")
Excelchat Expert 03/06/2018 - 05:27
The DATEDIF function is composed of three parts - 1) Start Date = B2, 2) End Date = TODAY(), 3) units = "Y" or in years
Excelchat Expert 03/06/2018 - 05:28
Could you follow so far?
User 03/06/2018 - 05:29
User 03/06/2018 - 05:30
if I remove the "Y" does it show it in days?
Excelchat Expert 03/06/2018 - 05:30
Cool. So the same formula is applied in cell D2
Excelchat Expert 03/06/2018 - 05:30
if you change "Y" to "d" then you get answer in days
Excelchat Expert 03/06/2018 - 05:34
I can see that you have deleted the original table. If you need more time, we are allowed for a maximum of 2 20-min free extensions per session
User 03/06/2018 - 05:34
I think i'll make it work
User 03/06/2018 - 05:34
I had problems trying it in my own table
Excelchat Expert 03/06/2018 - 05:34
Excelchat Expert 03/06/2018 - 05:35
I believe you could do it :)
Excelchat Expert 03/06/2018 - 05:35
If you don't have any more clarifications at this point, you may end the session by hovering over the TIME REMAINING section of this chat window and select END SESSION
Excelchat Expert 03/06/2018 - 05:35
Also, I'd appreciate if you could drop a few lines for your kind and honest feedback on a survey after this session. Any constructive criticism or points for improvement are also welcome. Many thanks and have a good day!
User 03/06/2018 - 05:35
Okay thank you!

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
The Allstate Corporation
United Parcel Service
Dell Inc