Practice TODAY & NOW Function Online in Excel

Watch: How to use TODAY & NOW Function in Excel?

What is TODAY Function?

The TODAY function in Excel returns the current date in a serial number format. Click here to Read full Tutorial

What is TODAY Function Syntax?

=TODAY()

Practice 1: TODAY Online Practice Excel

Click on any cell below to start practicing Today Function. Check Instruction how to use the Today Function.

Case 1: Instructions to use Today function

Click on cell G7 and type =Today()
Click on I8 and type =G8+I8

What is NOW Function?

The NOW function in Excel displays the current date and time in a worksheet Click here to Read full Tutorial

What is NOW Function Syntax?

=NOW()

Practice 2: NOW Online Practice Excel

Case 2: Instructions to use Now function

Click on cell G7 and type =Now()
Click on I7 and type =G7+H7

Excel Functions

EXCEL FUNCTION – FIND

ByPradeep Kumar

FIND function is used to find the position of text, or character in an available string.

Excel Functions

“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.

Excel Functions

EXCEL FUNCTION – INDIRECT

ByPradeep Kumar

INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.

Excel Functions

Excel TOCOL function – convert range to single column

BySumit Shrimal

An easy way to transform an array or range into a column with the TOCOL function. The ability to transpose data from columns to rows and in reverse has been in Excel for quite a…

Excel Functions

EXCEL FUNCTION – COLUMN

ByPradeep Kumar

COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.

Excel Functions

How to calculate NPV in Excel

BySumit Shrimal

In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.

Excel Functions