Hi. What i need is a way to work out a date (dd/mm/yyyy).
For example. I have a current age of 25 (date of birth 01/01/1979)
What i need to do is have another cell which will show me the date
where age of 75yrs and 1month and 1day would be displayed (etc.)
Is there an easy way? I am a system tester and have to test a few
scenarios where rules and validation are called depending on birthdays
and the like.
Thanks for reading
For example. I have a current age of 25 (date of birth 01/01/1979)
What i need to do is have another cell which will show me the date
where age of 75yrs and 1month and 1day would be displayed (etc.)
Is there an easy way? I am a system tester and have to test a few
scenarios where rules and validation are called depending on birthdays
and the like.
Thanks for reading