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