Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date/Today function
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Date/Today function
Resolved · Low Priority · Version 2007
Reply Thu 17 Jun 2010, 09:44Delegate Claire said...
Claire has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Date/Today function
Using the 'TODAY' function, is it possible to set a countdown in your worksheet (i.e. working towards a deadline)?
For upcoming training course dates see: Pricing & availability
RE: 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
Attached files...
countdown-to-deadline-example.xls
|