successive day counter from the specific time

Rocky Yadav
Rocky Yadav used Ask the Experts™
on
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 .
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
It can't when when the workbook is closed. If you want some sort of counter then the workbook must be open
Rob HensonFinance Analyst

Commented:
If a date and time are hardcoded into a cell, when the file is re-opened and recalculated the count will update.

Author

Commented:
@Rob Henson sir how to do this? please explain in detail.
Ensure you’re charging the right price for your IT

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

Rob HensonFinance Analyst
Commented:
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

Author

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
Rob HensonFinance Analyst

Commented:
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.

Author

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.
Finance Analyst
Commented:
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.

Author

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.
Rob HensonFinance Analyst

Commented:
Thanks for the feedback. Glad we got it sorted in the end.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial