Refreshing Date or Now function

D

dimitrz

Board Regular
Joined
Aug 30, 2007
Messages
55
Hi Guys,

Dont know wether this is possible!
But is it possible to have a function/formula/macro so that I can have a cell display the current date and time.

I know its possible using
Code: 
  =now()formula

however it does not get refreshed automatically - I want these cells to auto refresh with the current time say everyone hour or so.

The reason for this is I want to have a cloumn which show the correct number of days and time Lapsed since a request was created.

And these fileds will go Red if the day count is above 5 days.

Since there would be hundreds of rows added daily its not feasible to change each and every cell everday if you get my point

Thanks

Cross posted at
http://www.excelforum.com/excel-general/655573-refreshing-date-or-now-function.html
 
Sort by date Sort by votes
=NOW() will update every time the sheet recalculates. Unless it's closed, surely it will be recalculated more often than every hour...right? Sure there are ways to force it to recalc.

This in the workbook code will force a calc. every hour.

Code: 
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Private Sub Workbook_Open()
Sleep 3600000
Application.Calculate
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Update a date cell if changes are made two 2 other cells. Must function in 20 sections
Replies
9
Views
171
Micron
M
J
  • Question Question
Augmenting VBA to Refresh Specific before All Power Queries
Replies
2
Views
706
johnny51981
J
Z
  • Question Question
Countdown date
Replies
2
Views
174
Zatman
Z
E
  • Question Question
Stop counting cells when status is complete
Replies
4
Views
775
estanden
E
B
  • Solved
Copy and PasteSpecialValues of within a User-Defined Function
2
Replies
14
Views
288
Joe4
Joe4

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top