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
I can help you with that problem.
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
Please check
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
Have a great day ahead.
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.