Formula to determine a future date based on criteria
How can I set up a formula to determine the €śfuture date€ť base on criteria
after a preliminary €śdate€ť is entered?
Criteria: if an individual joins the team on the 1st of the month then the
person is eligible date for bonus is 60 days after. However, if an
individual joins the team after the 1st of the month then the person eligible
date for bonus will be after 60 days later and the following month.
Examples:
Date entered 03/01/2005, and then eligible date is 05/01/2005
Date entered 03/03/2005, and then eligible date is now 06/01/2005
--
Thanks,
David
|