answersLogoWhite

0

You select a cell, and type:
= now()


You can also make calculations involving the current date/time. For example, if in some cell you have a fixed date, you can use a formula involving now() to calculate how many days have passed from that date.
User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How do you get the current time in Microsoft Excel?

You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()You use the NOW function, like this:=NOW()


Which function will you use to enter current date and time in a excel worksheet cell?

The TODAY function can enter today's date in Excel. The DATE function can be used to build a date from the day, month and year elements.


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


Can you use Sum Function in school?

If you use Excel in school, then, yes, you can use the SUM function.


What is an excel function used to enter the system date in a cell in a worksheet?

The NOW function


To add numeric enteries quick in excel use the function?

Use the Sum function.


How do you use the all function in Excel?

you can get help in the Microsoft excel itself by pressing F1 key.


What does the now in Excel mean?

The NOW function puts in the current date and time into a cell. You enter it like this: =NOW()


What is quartile Excel function?

There is no function to create a quartile in Excel. A quartile is a 25% division of a statistical collection of data. You can use Excel to create a chart to let you observe the quartiles of the data.


Which function can be used to check whether the value is numeric or not?

In Excel you can use the ISNUMBER() function.


Which Excel function would you use when you want to determine a monthly loan payment?

The PMT function.


How do you do standard deviation on Microsoft Excel?

Use the STDEV() function.