# Excel - COLUMN Function Problem - Expert Solution

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

need a formula for when i put a date in one column in will tell me how many days today is from that date in the next column
Solved by D. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/08/2018 - 12:04
Hello, welcome to Got It Expert!
Excelchat Expert 17/08/2018 - 12:04
You want to know how many days today is from a specific date, right?
User 17/08/2018 - 12:04
correct
Excelchat Expert 17/08/2018 - 12:05
Excelchat Expert 17/08/2018 - 12:06
=TODAY()-A1
Excelchat Expert 17/08/2018 - 12:06
I use this formula to solve your problem.
Excelchat Expert 17/08/2018 - 12:06
User 17/08/2018 - 12:07
when i try i get a date that comes up not a number
Excelchat Expert 17/08/2018 - 12:08
Excelchat Expert 17/08/2018 - 12:08
You need to set column B as a numerical column.
Excelchat Expert 17/08/2018 - 12:09
And you need to transfer column A to a date type column.
User 17/08/2018 - 12:10
got it thanks
Excelchat Expert 17/08/2018 - 12:11
You are welcome.
Excelchat Expert 17/08/2018 - 12:11
So we are done with this session right?
User 17/08/2018 - 12:11
yes thanks
Excelchat Expert 17/08/2018 - 12:12
Hope you can get me a good rating. Thank you very much.
Excelchat Expert 17/08/2018 - 12:12
And have a good one.

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.