Register
Which of the following is NOT a unit value option for the DATEDIF? 1) H 2) M 3) D 4) Y
148k views
4 votes
Which of the following is NOT a unit value option for the DATEDIF?

1) H
2) M
3) D
4) Y

User The Guest
by
8.2k points

1 Answer

6 votes

Final answer:

The DATEDIF function in Excel calculates the difference between dates using certain unit value options. One of the options provided is not a valid unit value for the function.

Step-by-step explanation:

The DATEDIF function is used to calculate the difference between two dates in Excel. The unit value options for DATEDIF are:

  1. Y: years
  2. M: months
  3. D: days

Therefore, the option that is NOT a valid unit value for the DATEDIF function is H (hours).

User Oleksandr Fedorenko
by
9.2k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.2m questions

11.8m answers

Other Questions

A piston-cylinder device fitted with stops in the cylinder walls contains 2.1 kg of water initially at 150 kPa and 30 °C. Heat is transferred to the system until the final temperature reaches 250 °C. The
The bulk modulus of a fluid if it undergoes a 1% change in volume when subjected to a pressure change of 10,000 psi is (a) 0.01 psi (b) 0.001 psi (c) 0.00001 psi (d) 0.000001 psi (e) none of these
A car has an initial speed of 10 m/s. It then undergoes a constant acceleration of 0.05 m/s^2 over a distance of 5 km. Determine: a) The car final speed. b) The time needed to travel the 5 km.
In solid motors, HTPB and PBAN are two common types of plasticizers. a) True b) False
Where are all the controls on most circuits?
Link Copied!