Question

How to determine critical range zone for a stock in a instant time in excel sheet?

Answer 1

Explanation:

Insert a static date or time into an Excel cell

On a worksheet, select the cell into which you want to insert the current date or time.

Do one of the following: To insert the date, type the date (like 2/2), and then click Home > Number Format dropdown (in the Number tab) >Short Date or Long Date.