2 Replies Latest reply: Jun 20, 2014 4:14 AM by Ashfaq Mohammed RSS

    difference of dates

      hi!

      i'm working on this pivot table and i want to create a new column with the difference, expressed in number of month, between the column called "mese anno chiusura" and "mese anno apertura", but as you can see there are some cells that not contain dates because the cases are still open; so how can I get a new column with the difference between the dates and where there is no date in column called "mese anno chiusura" is reported "open" in the new column?!

       

      1.JPG.jpg