Calculating the current date and time in a worksheet cell
If you want to enter the current date and/or time into a cell so that it automatically stays current, use the NOW() or TODAY() formulas.
The NOW() function
To get the date and/or time, simply type =NOW() into a cell and press ENTER. That will enter the current date and time into that cell.
Then, right click the cell and choose Format Cells. Choose the Number tab, then choose the Date category (if you want to display just the current date) or theTime category (if you just want to display the current time). Pick a format that suits you, then click OK. Excel will display the current date and time in the format you chose. If you chose a Date format, Excel will not display the time (although the formula in the cell still calculates the time as well). The opposite is true if you choose a Time format.
The TODAY() function
If you only want to enter the current date into a cell and have it stay up to-date, type =TODAY() into a cell and press ENTE. This formula will calculate today's date and place it in the cell. As above, you can format the cell to change the way the date displays.
About Us
Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. We're starting with lessons on Microsoft Word, Excel and PowerPoint but have plans to add other subjects over time such as Adobe Photoshop and Microsoft Project as well as non-software subjects.
We're based in Tauranga, New Zealand but have years of experience in the UK, USA and Ireland working in the training industry with a range of clients from small businesses to blue chip corporates.
Commercial Services
As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:
- Private labelling
- Courseware development
- e-learning development
- Corporate subscriptions
- Learning consultancy services
- Documentation and user guide development
- Development of innovative corporate learning environments
We offer these services for Microsoft Word, Excel and PowerPoint, as well as a range of other popular software applications. We can also assist with documentation and courseware development for custom or in-house software packages.
Contact us now to find out more about our learning consultancy and courseware development services