Hi Ed,

This can be done but you will need to write code to do it. Is that
something you want?

Sub my_Procedure()
Application.OnTime Now + TimeValue("00:30:00"), "my_Procedure"
Application.Calculate
End Sub

This actually calculates the entire application which automatically updates
all volatile functions of which NOW is one. You can limit the area that is
recalculated to a sheet for example. Place the above code in a regular code
module.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Ed's" wrote in message
...
Hey,

I am wanting to find out if the NOW() function can be updated
automatically
every 30 minutes - i have a formula which changes a date to tomorrows if
it
is after 5pm - but the now function obviously doesn't update
automatically.

Can any bodyhelp?