# Excel - COLUMN Function Problem - Expert Solution

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

I need to use birth date in one column and date of entry into program in another and round to the nearest tenth decimal
Solved by T. Q. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/11/2017 - 08:08
Hello.
User 24/11/2017 - 08:08
hi
User 24/11/2017 - 08:09
I have birth dates in a2-a17 and date of entry dates c2-c17
User 24/11/2017 - 08:09
how do i find the age at date of entry rounded to the nearest 10th?
Excelchat Expert 24/11/2017 - 08:10
Ok I see
Excelchat Expert 24/11/2017 - 08:11
To determine the age you need to find the difference between dates.
Excelchat Expert 24/11/2017 - 08:12
See the difference at the col D
User 24/11/2017 - 08:12
where? I've never used this before
Excelchat Expert 24/11/2017 - 08:12
The number is the age by days.
User 24/11/2017 - 08:12
what formula did you use
Excelchat Expert 24/11/2017 - 08:13
=C2-A2
Excelchat Expert 24/11/2017 - 08:13
date at col C - date at col A
Excelchat Expert 24/11/2017 - 08:14
It you need the date by years you just need to divide the result by 265
User 24/11/2017 - 08:14
okay so whats the formal to get c2 thru c17-a2 thru a17
Excelchat Expert 24/11/2017 - 08:16
See the result at col E
Excelchat Expert 24/11/2017 - 08:16
Just insert the formula at cell D2 and drag it for all cells.
User 24/11/2017 - 08:18
okay i dragged it
User 24/11/2017 - 08:18
now how do i do the formula to get the days and decimals
User 24/11/2017 - 08:18
thanks for the help fyi
Excelchat Expert 24/11/2017 - 08:20
ok
User 24/11/2017 - 08:21
is the e column rounded to nearest tenth?
Excelchat Expert 24/11/2017 - 08:21
Yes.
User 24/11/2017 - 08:22
mine didn't work i typed in e colloid =d2/365
User 24/11/2017 - 08:24
oh i see thats because mine is b not d
Excelchat Expert 24/11/2017 - 08:27
Yes
Excelchat Expert 24/11/2017 - 08:27
You need to round the age.
Excelchat Expert 24/11/2017 - 08:28
Or you need to calculate years and months and days.
User 24/11/2017 - 08:28
okay so now i want to subtract column c from column d discharge date
User 24/11/2017 - 08:29
is it =c2-f2
Excelchat Expert 24/11/2017 - 08:29
Why is that?
User 24/11/2017 - 08:30
because c is entry day into service and f is discharge day
User 24/11/2017 - 08:30
so i need to know how many days they stayed
Excelchat Expert 24/11/2017 - 08:30
Ok
Excelchat Expert 24/11/2017 - 08:34
But you need to the formula =F2-C2
Excelchat Expert 24/11/2017 - 08:35
because discharge is greater than entry date.
User 24/11/2017 - 08:36
how do i get answer it col G?
Excelchat Expert 24/11/2017 - 08:37
Just insert the formula at column G.
User 24/11/2017 - 08:37
okay got it
Excelchat Expert 24/11/2017 - 08:37
Excelchat Expert 24/11/2017 - 08:39
User 24/11/2017 - 08:40
probably but for now I'm ok
Excelchat Expert 24/11/2017 - 08:42
Ok

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.