starryexcel
New Member
- Joined
- Aug 30, 2016
- Messages
- 6
I have searched and searched so I am now asking my first question.
I am looking for the formula to give me 1 year after date of hire, Jan 1 or Jul 1 whichever comes first to provided the date of open enrollment for 401K.
Cell A1 (Today's Date)
Cell J9 (Date of Hire)
Cell Q9 (Eligibility date, either 1/1 or 7/1, one year after cell J9)
Thank you for help "excel wonders of the world"...
I am looking for the formula to give me 1 year after date of hire, Jan 1 or Jul 1 whichever comes first to provided the date of open enrollment for 401K.
Cell A1 (Today's Date)
Cell J9 (Date of Hire)
Cell Q9 (Eligibility date, either 1/1 or 7/1, one year after cell J9)
Thank you for help "excel wonders of the world"...