Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

I have been training for a fair few years now, and I still get surprised by what people do not know what Excel can do. When it comes to dates and time some people do not know that they are values that ...

The NOW () function returns the day’s date along with the current time in Excel’s digital date format. So if it’s noon on 21 December 2012, the =NOW ()formula would return the result 41,264.50 in your ...