10 Replies Latest reply: Jul 29, 2014 5:38 AM by Lucy Chapman RSS

    How to find the anniversary of a start date in a particular year?

      START_DATEAnniversary of start date in 2012/3
      15/09/200815/09/2012
      26/01/201026/01/2013
      13/09/201013/09/2012
      31/03/201131/03/2013
      17/09/201217/09/2012
      24/01/201324/01/2013

       

      Hi all,

       

      I have figures for the start date of employees (column 1 above)  and need something in the script to work out the anniversary of their start date in the current year. I have used 2012/3 as an example. I am looking to use the date in the first column to find the date  in the second column which I do not have. 

       

      Any help would be much appreciated as I have been going round in circles on this one

       

      Many thanks