# Excel - COUNT Function Problem - Expert Solution

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

I need a formula to count days from an historic date to current date
Solved by T. Q. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/09/2018 - 08:11
Hello
Excelchat Expert 14/09/2018 - 08:11
Welcome to Excelchat, I see that your question is about the formula for Number of days
User 14/09/2018 - 08:11
Hi
Excelchat Expert 14/09/2018 - 08:11
Excelchat Expert 14/09/2018 - 08:12
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 14/09/2018 - 08:12
I only have one problem
Excelchat Expert 14/09/2018 - 08:12
Let me ask you a couple of quick questions to make sure I fully understand your problem
User 14/09/2018 - 08:12
OK
Excelchat Expert 14/09/2018 - 08:13
So if you will see the column B on the right on preview
User 14/09/2018 - 08:13
Yes that's correct
Excelchat Expert 14/09/2018 - 08:13
Let's suppose this is the historical date
Excelchat Expert 14/09/2018 - 08:13
So we need the number of days till present date?
User 14/09/2018 - 08:14
Yes
Excelchat Expert 14/09/2018 - 08:14
Ok
Excelchat Expert 14/09/2018 - 08:14
I’m going to build a formula for you. This should take me few minutes to solve. If prompted for extension of session, please do so.
User 14/09/2018 - 08:14
Our historic days don't go back that far but I suppose the formula will be the same ?
Excelchat Expert 14/09/2018 - 08:14
Yes, it would be
Excelchat Expert 14/09/2018 - 08:15
Here it is.
Excelchat Expert 14/09/2018 - 08:15
Excelchat Expert 14/09/2018 - 08:16
Let me tell you how this =today()-B3 works
Excelchat Expert 14/09/2018 - 08:16
Today() will give today's date always
Excelchat Expert 14/09/2018 - 08:16
so we getting today's date using this function and then subtracting the historical date from it.
Excelchat Expert 14/09/2018 - 08:17
to get the number of days
Excelchat Expert 14/09/2018 - 08:17
Does this solution solve your problem?
User 14/09/2018 - 08:17
But the answer is incorrect, there is less days than 129
Excelchat Expert 14/09/2018 - 08:17
the format for the date used is mm/dd/yyyy
Excelchat Expert 14/09/2018 - 08:18
I have used 1st September Now
Excelchat Expert 14/09/2018 - 08:18
you can use this on any format for date you like.
Excelchat Expert 14/09/2018 - 08:19
Please click on the Historical Date cell and change the date as per your need and see the formula working.
User 14/09/2018 - 08:19
Right, thank you. We Brits use a different format for date.
Excelchat Expert 14/09/2018 - 08:20
I apologies. I should have asked that before hand.
Excelchat Expert 14/09/2018 - 08:20
My apologies
Excelchat Expert 14/09/2018 - 08:20
Please double click on the cell
Excelchat Expert 14/09/2018 - 08:20
it will open a calendar and you can select the date.
Excelchat Expert 14/09/2018 - 08:20
08/24/2018
Excelchat Expert 14/09/2018 - 08:21
When you will use this formula in your file on your system it will take the format you have used there.
Excelchat Expert 14/09/2018 - 08:21
Does this solution solve your problem?
User 14/09/2018 - 08:22
That is brilliant thank you so much, you have saved me hours trying to work this one out.
Excelchat Expert 14/09/2018 - 08:22
Great!
Excelchat Expert 14/09/2018 - 08:22
Thanks for coming to Excelchat.
Excelchat Expert 14/09/2018 - 08:22
Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side and requesting you to provide good feedback and review so that I can continue my services to others.
User 14/09/2018 - 08:22
Bye bye and have a good day
Excelchat Expert 14/09/2018 - 08:22

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.