Question:
Which Date and Time function returns the value of today’s date with time?
Which Date and Time function returns the value of today’s date with time?
Show Hint
Use Now() for date-time stamps and Today() for dates when analyzing or managing time-based data in Excel.
Updated On: Jan 13, 2026
- Today()
- Day()
- Now()
- Day time()
Hide Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
- The Now() function in Excel returns the current date and time.
- The Today() function returns only the current date without the time.
Was this answer helpful?
0
0
Top Questions on Miscellaneous
- Three persons enter a lift at the ground floor. The lift will go up to the 10th floor. The number of ways in which the three persons can exit the lift at three different floors, if the lift does not stop at the 1st, 2nd and 3rd floors, is equal to _______.
- JEE Main - 2026
- Mathematics
- Miscellaneous
- If \[ \sum_{r=1}^{25}\left(\frac{r}{r^4+r^2+1}\right)=\frac{p}{q}, \] where \(p\) and \(q\) are positive integers such that \(\gcd(p,q)=1\), then \(p+q\) is equal to _______.
- JEE Main - 2026
- Mathematics
- Miscellaneous
- The sum of all the elements in the range of
\[ f(x)=\operatorname{sgn}(\sin x)+\operatorname{sgn}(\cos x) +\operatorname{sgn}(\tan x)+\operatorname{sgn}(\cot x), \]
where
\[ x\neq \frac{n\pi}{2},\ n\in\mathbb{Z}, \]
and
\[ \operatorname{sgn}(t)= \begin{cases} 1, & t>0 \\ -1, & t<0 \end{cases} \]
is:
- JEE Main - 2026
- Mathematics
- Miscellaneous
- Let \[ A=\{z\in\mathbb{C}:|z-2|\le 4\} \quad\text{and}\quad B=\{z\in\mathbb{C}:|z-2|+|z+2|=5\}. \] Then the maximum value of \(|z_1-z_2|\), where \(z_1\in A\) and \(z_2\in B\), is:
- JEE Main - 2026
- Mathematics
- Miscellaneous
- Considering the principal values of inverse trigonometric functions, the value of \[ \tan\!\left(2\sin^{-1}\!\frac{2}{\sqrt{13}}-2\cos^{-1}\!\frac{3}{\sqrt{10}}\right) \] is equal to:
- JEE Main - 2026
- Mathematics
- Miscellaneous
View More Questions
Questions Asked in CBSE CLASS XII exam
If vector \( \mathbf{a} = 3 \hat{i} + 2 \hat{j} - \hat{k} \) \text{ and } \( \mathbf{b} = \hat{i} - \hat{j} + \hat{k} \), then which of the following is correct?
- Find the value of $x$, if \[ \begin{bmatrix} 1 & 3 & 2 \\ 2 & 5 & 1 \\ 15 & 3 & 2 \end{bmatrix} \begin{bmatrix} 1 \\ x \\ 2 \end{bmatrix} = \begin{bmatrix} 0 \\ 0 \\ 0 \end{bmatrix} \]
- Two point charges of \( -5\,\mu C \) and \( 2\,\mu C \) are located in free space at \( (-4\,\text{cm}, 0) \) and \( (6\,\text{cm}, 0) \) respectively.
(a) Calculate the amount of work done to separate the two charges at infinite distance.
(b) If this system of charges was initially kept in an electric field \[ \vec{E} = \frac{A}{r^2}, \text{ where } A = 8 \times 10^4\, \text{N}\,\text{C}^{-1}\,\text{m}^2, \] calculate the electrostatic potential energy of the system.- CBSE CLASS XII - 2025
- Electrostatics
- 4,000 shares of ₹ 10 each were forfeited for non-payment of second and final call money of ₹ 2 per share. The minimum amount that the company must collect at the time of reissue of these shares will be :
- CBSE CLASS XII - 2025
- Accounting for Share Capital
- If $y = a \cos(\log x) + b \sin(\log x)$, then $x^2y'' + xy'1$ is:
- CBSE CLASS XII - 2025
- Continuity and differentiability
View More Questions