 # 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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