Forum Discussion
Date Values and Event Sequencing
Hello, I've inherited a spreadsheet to manage fitness data and there appears to be errors in some cells but not in others. In the picture attached: - There is no date value in cell H2 but th...
christ7 Hi, I believe it all has to do with the format of the date in the "Test Date" column. You will notice that error only occurs when the day is greater than 13 for example 13/Sep/2017. if you change the date to 12/Sep/2017 then your formula will work.
If you change the formula in the "Date Value" column to be DAY, MONTH, YEAR instead of MONTH, DAY, YEAR then the formula will work, although I haven't checked that you get the correct answer.
