Please help with date logic problem
Closed
CRIZ
-
Mar 2, 2012 at 09:57 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 06:42 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 06:42 PM
Related:
- Identify the logical error in the program to print the following pattern 11 1111 111111
- Draw print pattern 11 1111 ✓ - Programming Forum
- An error occurred while sending the message facebook - Facebook Forum
- Print nightmare fix - Guide
- Facebook.com/login/identify ✓ - Facebook Forum
- Cmos checksum error - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 24, 2012 at 06:42 PM
Mar 24, 2012 at 06:42 PM
This should do it
E11 : dependent 18th birthday
B11: employee hire data
Employee completion of 5 year
=DATE(YEAR(B11)+5,MONTH(B11),DAY(B11)-1)
number of years between employee 5th year and dependent 18th birthday
=IF(E11<DATE(YEAR(B11)+5,MONTH(B11),DAY(B11)-1),0,DATEDIF(DATE(YEAR(B11) +5, MONTH(B11), DAY(B11) -1),E11,"Y"))
E11 : dependent 18th birthday
B11: employee hire data
Employee completion of 5 year
=DATE(YEAR(B11)+5,MONTH(B11),DAY(B11)-1)
number of years between employee 5th year and dependent 18th birthday
=IF(E11<DATE(YEAR(B11)+5,MONTH(B11),DAY(B11)-1),0,DATEDIF(DATE(YEAR(B11) +5, MONTH(B11), DAY(B11) -1),E11,"Y"))