Date/Today function

Hi Claire,

Thanks for your question. I hope you are enjoying the Excel Introduction training.

The simplest way is use the NOW() function.

Step 1. Put the deadline date in cell A1
Step 2. Put this formula in any other cell:
=A1-NOW()
Step 3. Format the latter cell to be a number, with no decimal places. It will result in the number of days remaining until the deadline.

See attached an Excel 2003 spreadsheet with this example, and also a more complex and detailed example which shows days, hours, minutes, seconds.

If this answer resolves your query, please mark the question as 'resolved' (see below). Otherwise, please post a follow-up response to this post, and I will assist you further.

Regards, Rich