I'm fairly new to Excel and am trying to replicate a spreadsheet I used to
use at work.

Basically, in column B I have a date some time in the future. What I am
trying to get in column A is a formula that will update every day to tell me
how many days remain until the date I have entered in column B. (Essentially
the date in column B minus today's date).

Hopefully that makes sense? I am using the 2000 version if that makes a
difference?

Any help would be greatly appreciated.

Thanks!