I need to update an Excel table daily

[Guest]

My question is....and I am not sure it is possible.....but here goes....I
have a table that needs to be reviewed everyday. It is one of those tables
that needs to track the number of days left before a certain event happens.
My question is.....is it possible to have excel update that particular column
each time I open the spreadsheet? Meaning, if I open the spreadsheet today,
November 11th is there a formula that will allow Excel to calculate the
number of days left ? ie (event date minus current date equalling number of
days left) does that even make sense?

 

[Alan]

Not with a formula I dont think, at least not to update anything, but its
quite easily done using VB code with a WorkBook_Open event,
Try posting more detail of what you want it to do,
Regards,

 

[Gord Dibben]

Silva

Assuming future event date November 24, 2004 is in A1

In B1 enter =A1-TODAY() & " days to go" returns 13 days to go.

Make sure Tools>Options>Calculation is set to "Automatic".

B1 will update each day, counting down the days to go.

Gord Dibben Excel MVP