Forum Discussion

timknox's avatar
timknox
Helper II
7 years ago
Solved

Return a string from a table based on a date

I wonder if anyone can help......   I have a table:   Date Month AP Index 01 April 2018 4 AP 1 0 01 May 2018 5 AP 2 1 01 June 2018 6 AP 3 2 01 July 2018 7 AP 4 3 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    ="AP "&IF(MONTH([Latest Date])<4,MONTH([Latest Date])+9,MONTH([Latest Date])-3)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

="AP "&IF(MONTH([Latest Date])<4,MONTH([Latest Date])+9,MONTH([Latest Date])-3)
  • timknox's avatar
    timknox
    Helper II
    7 years ago

    many thanks