Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 4 variables.
vMaxMth1
vMaxMth2
vMaxMth3
vMaxMth4
If I have value in vMaxMth1 = 31/08/2014'. I need other 3 variables file up as below.
vMaxMth2 - 31/07/2014
vMaxMth3 - 30/06/2014
vMaxMth4 - 31/05/2014.
How can I do that?
vMaxMth2
=AddMonths('$(vMaxMth1)',-1)
vMaxMth3
=AddMonths('$(vMaxMth1)',-2)
vMaxMth4
=AddMonths('$(vMaxMth1)',-3)
vMaxMth2
=AddMonths('$(vMaxMth1)',-1)
vMaxMth3
=AddMonths('$(vMaxMth1)',-2)
vMaxMth4
=AddMonths('$(vMaxMth1)',-3)