Make a cell count up every X time

[tcourter]

Hey there,

I'm working on a Sales Report spreadsheet for my organization and I'm trying to automate as much of it as I possibly can. A lot of the calculations that are baked into the report rely on dividing a number by a cell that contains how many days have gone by so far.

For example, let's say that your sales goal for the month is $100,000. If today is the 3rd day of the month, you can take your goal ($100,000) and divide it by the number of days in the month (28) and then multiply that by the number of days that have passed so far (2), giving you your "Goal to Date" (7,142.86).

I currently have a cell in my sheet that contains the number of days that have passed so far, but that number must be updated manually. Is there anyway I can make this cell count up automatically? Better yet - can I make it count up incrementally every hour? At the moment, I have the ability to update the current sales numbers every hour. Is there anyway I can make it so that my "days so far" cell counts up by 0.04167 every hour?

Perhaps someone knows a better solution to this concept. Any help or advice is greatly appreciated!

 

[awoohaw]

Hourly: =Minute(Now()) = 0, but it will only update after you perform some kind of calcution.

 

[pjmorris]

put =NOW() in a the cell - it shows the date and time of when the sheet was last 'calculated'. Subtract that from the date of the start of the period and you will have the time to go. If no calculation is occurring (no new data added) then simply press F9.

HTH

 

[tcourter]

This is absolutely perfect! Thank you so much.

 

[pjmorris]

a pleasure, thanks for the acknowledgement.