Forum Discussion
Days on Excel
I am having issues with me Excel Spreadsheet and I am not sure why as I am sure I have done all the necessary steps.
HLCARR Well, if you don't tell more about the 'issues' and 'all the necessary steps taken' it will be difficult to help.
I will give an example. In A3 I have written the 16.11.23 in A5 I have written 19.11.23. In A8 I want to calculate the amount of days between A3 & A5 So I click on A8 then Formulas, then Time & Date then days and then I click in the A5 grid for the end date and the A3 grid for the start date and press enter and I get the VALUE error word pop up.
I have changed the number category to date for all three grid squares and have changed changed the number format to English United States but I still get the VALUE pop up saying the wrong data type has been used.
What happens if you enter 16-Nov-23 in A3 and 19-11-23 in A5?
You can also use the formula
=A5-A3
