I need a formula for the following:
Cell E45 = 8/9/2002 (retire date)
Cell E46 = 6/1/1943 (birth date)
In cell E47, I will be subtracting the two dates to get the age in years and months.
In cell E48, I will be subtracting the two dates to get the age in months.
I need it to compute as follows: if cell E45 is <=28 (28th day of month), then I need it to compute effective the following month -- in this case, 9/1/2002. If cell E45 is >=28, then compute on that date.
Thanks in advance for your help.
Cell E45 = 8/9/2002 (retire date)
Cell E46 = 6/1/1943 (birth date)
In cell E47, I will be subtracting the two dates to get the age in years and months.
In cell E48, I will be subtracting the two dates to get the age in months.
I need it to compute as follows: if cell E45 is <=28 (28th day of month), then I need it to compute effective the following month -- in this case, 9/1/2002. If cell E45 is >=28, then compute on that date.
Thanks in advance for your help.