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
Please check the google sheet on the left half screen.
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
Please check out the column B in the google sheet.
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
Can you send me your spreadsheet?
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.