leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- Windows
Hello forum friends, need help with this formula as it is returning a result of 19919 if I enter a date of birth in 'personal information'!E5.
I entered May 6, 1954 in 'personal information'!E5 hoping to see a result of 2019.
Appreciate any help or advice on this one. Thanks!
I entered May 6, 1954 in 'personal information'!E5 hoping to see a result of 2019.
Code:
=IF('personal information'!E5=0,"",'personal information'!E5+69)
Appreciate any help or advice on this one. Thanks!