PPRuNe Forums - View Single Post - I used it, then it vanished.
View Single Post
Old 31st December 2016 | 05:36
  #3 (permalink)  
jimjim1
 
Joined: Oct 2007
Posts: 1,003
Likes: 16
From: Here
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  
Reply