Forum Discussion
Solved
Datevalue+timevalue returns "the cell currently being evaluated contains a constant"
Hello guys, I would like to receive some help from you, as i cannot understand why my formula works for some values and for others isn't. So, in date1 column, i have a formula applied t...
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.