Quote:
Originally Posted by Claus Busch
Hi Elizabeth,
Am Tue, 23 Sep 2014 21:15:14 +0100 schrieb ElizabethWells:
3/8/2013 would return 7/1/2013
or
8/21/2014 would return 1/1/2015
try:
=DATE(YEAR(A1),IF(MONTH(A1)<7,7,13),1)
or
=EDATE(A1,IF(MONTH(A1)<7,7,13)-MONTH(A1))-(DAY(A1)-1)
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|
Thanks to you too Claus!
BTW, this helps determine correct plan entry for those plans (401(k), profit sharing etc.) that have those two entry dates. Thanks again!