Forum Discussion
Days on Excel
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
- I seem to have the same issue!
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Dates and times can be tricky. Here's a full list of date and time functions, with links to more details on each. You might be able to solve your own problem -- and learn a lot in the process -- by poking around and using trial and error with these.
