Get instant live expert help on datevalue function in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How can I modify the below formula to also exclude the values of S43 and/or U43 if T43 and/or V43 are empty?
=IF(AND(V43<DATEVALUE("5/5/2018"),T43<DATEVALUE("5/5/2018")),S43+U43,IF(V43<DATEVALUE("5/5/2018"),U43,IF(T43<DATEVALUE("5/5/2018"),S43,0)))
I'd like it to follow the same logic, e.g., if T43<DATEVALUE("5/5/2018"),S43 but to specify that if T43 is blank, then not include S43 in the cell.
Solved by O. L. in 28 mins
=IF(DATEVALUE(TEXT(F295,"mm/dd/yyyy"))<DATEVALUE(TEXT(4/23/18, "mm/dd/yyyy")),"XLN")
---------------------------------
What is wrong with the above formula?
Solved by O. C. in 11 mins
I need to modify the formula in Column Q to now have a greater than limitation on the date value. Currently cells in column Q will populate if the datevalue in column T or column V is less than 6/5/2018. I also need to add in that cells in column Q will only populate if the datevalue is between 5/5/2018 and 6/4/2018.
Solved by A. L. in 23 mins
I cannot figure out why the formula in Column O is not working. It should work as such:
If the corresponding cells in column T are V are empty, nothing should display in column O
If the corresponding cell in column T is empty, but the corresponding cell in column V is < DATEVALUE 6/5/2018, the value of column U should populate in column O.
Same thing with column T: if column T is populated with a datevalue <6/5/2018, and column V is empty, the value in column S should populate in column O.
If both columns T and V have a datevalue of <6/5/2018, the values of columns S and U should sum in column O.
I can't see where the error is. Please help!
Solved by C. F. in 24 mins
In EXCEL 2016 HOUR Function in SQL fails with "Hour is not a recognized function
Solved by M. J. in 15 mins