Hello !
How can i but excel automatically count numbers from certain date. So that the number will change everyday by 1.
example: from 23.09 counting that day in. Number will start to count everyday by 1.
Thank you ! Sry about my english...
Hello !
How can i but excel automatically count numbers from certain date. So that the number will change everyday by 1.
example: from 23.09 counting that day in. Number will start to count everyday by 1.
Thank you ! Sry about my english...
Hi, user this:
=1+TODAY()-A1
where the start date is in A1.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi ! Thx for reply. I dont know if im doing it wrong...
But i would like to get a number so that if it starts counting from 23.09.15 the number today would be 5 and tomorrow 6 and so on...
So it would just count days automaticly.
Thanks !
That is what that formula does... Did you notice the amendment 1+ to count the start day as well. i think that you should post a sample excel sheet, explaining more clearly what you want.
Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
I dont want date. I need just a number in one cell that will automaticly add +1 to it everyday.
Thanks !
My formula is NOT giving you a date. It gives you a NUMBER. Did you actually try it? If you are counting days, you HAVE to know where to start from. Do you want it to start from yesterday or 24th June 1947? An alternative (which gives the exact same result, but hard-coding the start date) is:
=1+TODAY()-"23/9/2015"
formatted as general.
The blue cell (D1) is a inputcell
Probably you are looking for the result in the green cells (column D).
It is made with countif.
See the attached file.
In the future, it would be nice if you add the excelfile, without confidential information yourself.
Added:
Sry, this should be sorry.Please Login or Register to view this content.
Last edited by oeldere; 09-27-2015 at 04:12 AM. Reason: Thank you ! Sry about my english...
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
OK, thank you !
Since you get answer of several forummembers it is alway good to add to who you are replying (Glenn or Oeldere)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks