PPRuNe Forums - View Single Post - I used it, then it vanished.
View Single Post
Old 31st Dec 2016, 05:36
  #3 (permalink)  
jimjim1
 
Join Date: Oct 2007
Location: Here
Posts: 965
Received 3 Likes on 2 Posts
You can do this pretty easily in Excel - as I recall:-)

And presumably in Libre Office.

Just tried excel and by typing the dates in as
a1 -> "23 may 2016"
b1 -> "23 june 2016"
Excel recognised the entries as dates.

and in an adjacent cell "=b1-a1"

poof - presto done.

Cells were automatically sorted out with correct everything to display days between.

23-May-16 23-May-17 365
jimjim1 is offline