I am trying to work out how to calculate the amount of days between 2 dates in an excel sheet. The format is like below,

=A348-A347 ? Or more fancy way: =DATEDIF(A347,A348,"d") Excel gets a bit screwy if the date isn't actually a "date" format. Can happen when you copy in dates from a text source, and it dumps it as text.

Sweet! Somebody I can ask what the d stands for because I've found when I put something else in there, the formula doesn't work. Edit: and text to columns fixes the numbers as text issues.. Or paste as values (if didn't already know that)

See here for more info: https://exceljet.net/excel-functions/excel-datedif-function "d" returns the number of days. Can also be used for months ("m") and years ("y"). Strangely, there's no context help when you use it in current versions. The link above suggests it was only documented in version 2000. I guess because it's so easy to just do your simple arithmetic between two cells. No conversions needed. There's extra formula you can use if you need to calculate the difference in hours/minutes, for example.