Feb 21 2022 01:40 AM - edited Feb 21 2022 02:58 AM
Hey,
I'm currently struggling with something which will most probably be easy to solve.
I've been using the formula =datedif for a longer time, but now I'm working with a new excel sheet and it does not work anymore. I've been able to solute the problem by using the formulat =INT, but now I have to calculate the difference between two specific dates instead of the difference between then and now. When going to 'evaluate formula' to look where it goes wrong, it does not show one of the dates as a serial number and when trying to convert it to a serial number using the formula =datevalue, it again shows the normal date instead of the serial number. I also tried to look at cell properties, but when trying another annotation, it does not work either.
Do you guys perhaps have the solution?
B2 = 28-01-2015, V2 = 11-12-2021. As you can see V2 becomes a serial number when using it in the formula (as we want it to)
kind regards,
Reinier
Feb 21 2022 01:54 AM
Show the date or number depends on format you applied, If that's a date. If you use text DATEVALUE() works if texts meets your regional setting formats. Perhaps something else, but that's better to discuss with sample or at least with screenshot.
Feb 21 2022 02:59 AM
Feb 21 2022 04:18 AM