Forum Discussion
Datevalue+timevalue returns "the cell currently being evaluated contains a constant"
you made a mistake in the function argument separators.
after TEXT(H2 you used ;
in some machines the functions argument separators is either comma or semicolon.
so part of your formula uses comma and part of it semicolon which is not correct.
you can use only one type of separator depending on the regional language setting of your machine.
please see attached file that demonstrates that formula is working.
can you try with this
=IFERROR(DATEVALUE(B2)+TIMEVALUE(B2),TEXT(B2,"General"))
Not working :(
you made a mistake in the function argument separators.
after TEXT(H2 you used ;
in some machines the functions argument separators is either comma or semicolon.
so part of your formula uses comma and part of it semicolon which is not correct.
you can use only one type of separator depending on the regional language setting of your machine.
please see attached file that demonstrates that formula is working.
Thank you very much for solving this one. I really appreciate it. I have used the ";" separator and now the formula works for those that were showing the #value error.
Now - a new "issue" occurs - as i have attached the photos, although all the cells are formatted with the same date type, as you can see it shows different formats for my dates. Therefore, when i hit the dropdown list in order to filter by months/years whatever, it shows the years, if i expand the years it shows the months but unfortunately the ones that previously had #value, are not included in the years/months, and are shown separately after the years.
Do you have any idea how i can solve this one as well?
Once again, thank you so very much for your help!
