successive day counter from the specific time

dear expert i want a successive day counter in my excel...start from the specific time .when 24 hour complete from the start time ....it has to show "DAY-1"... after 24 hour it show "DAY-2"...and so on....and should be continue either sheet is open or close.
can you help please?
waiting for your response .
Rocky YadavAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
It can't when when the workbook is closed. If you want some sort of counter then the workbook must be open
0
Rob HensonFinance AnalystCommented:
If a date and time are hardcoded into a cell, when the file is re-opened and recalculated the count will update.
0
Rocky YadavAuthor Commented:
@Rob Henson sir how to do this? please explain in detail.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Rob HensonFinance AnalystCommented:
See attached.

As time goes on the reference to 31 Aug will stay the same but the calculations use TODAY and NOW as a comparison.

TODAY returns current Date
NOW returns current Date and Time

NETWORKDAYS only looks at whole days anyway and can be used to exclude holidays and weekends if required.

Dates are held in excel as a serial number representing number of days since 1 Jan 1900 so a simple formula with "End Date minus Start Date" will give number of days between. Using NOW function then allows for the time portion as well.
Day-Count.xlsx
0
Rocky YadavAuthor Commented:
@Rob Henson sir thanks for trying to solve my problem...but it is not what i want.let me explain again with example it may help you to understand my problem.
sir actually i am in fisheries business ...so simply i want a day counter in my excel like attached file.no date and time entry again and again. suppose i want to count my day from today 10 pm and next day 10 pm it should show DAY-1 next day 10 pm it should show DAY-2 and so on....and it should continue either file close.and i want to remember how many days old fish is in particular pond by seeing this day counter.....That's because I can give them food according to the days........i am sure you will help to make this counter.
thanks.
day_counter.xlsx
0
Rob HensonFinance AnalystCommented:
In order to have a count you need to have some start point. That can be a fixed value in a cell or some attribute of the file, eg creation date.

In your example, you would need to set the start point at 10pm today (4 Sept 18 22:00) in order to do a count from that point.
0
Rocky YadavAuthor Commented:
@Rob Henson sir thanks to solve my problem....it is great pleasure to connect with you......now i got exactly what i wanted.
but there is a little problem day is not changing automatically when cross the certain time until i click on time
(cell B4) and press enter .please tell me if i am doing mistake.
thanks again and again.
0
Rob HensonFinance AnalystCommented:
That is because there is no recalculation until you force it to happen.

To force a calculation you can do such as you are doing, enter/confirm a value in one of the cells. Alternatively you can just press F9 to force calculation on the workbook.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rocky YadavAuthor Commented:
@Rob Henson sir i am so grateful for your answer.you really have a great knowledge.

thanks to all experts who gave me their valuable time.
0
Rob HensonFinance AnalystCommented:
Thanks for the feedback. Glad we got it sorted in the end.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.