Jul 28 2020 12:58 PM
Jul 28 2020 01:06 PM
Let's say the start date is in A2. The following formula hopefully returns the date that you want:
=WORKDAY(EOMONTH(A2,3)+14,1)
Jul 28 2020 04:06 PM
Jul 29 2020 12:55 AM
EOMONTH(date, n) returns the last day of the month n months after date. So EOMONTH(A2,3) is the last day of the month 3 months after the date in A2.
If you want the date one year (12 months) after the date returned by the formula, you can use
=WORKDAY(EOMONTH(A2,15)+14,1)
Jul 29 2020 05:53 AM
Jul 29 2020 06:41 AM
Jul 29 2020 06:54 AM
Let's say A2 contains 29-Jul-2020.
EOMONTH(A2,3) is the last day of the month 3 months after that, i.e. 31-Oct-2020.
EOMONTH(A2,3)+14 adds 14 days to that, i.e. 14-Nov-2020.
WORKDAY(EOMONTH(A2,3)+14,1) returns the first (1) working day after that. Since 15-Nov-2020 is a Sunday, the formula returns 16-Nov-2020, a Monday.
Jul 29 2020 06:55 AM
Jul 29 2020 11:49 AM
Jul 31 2020 08:14 AM
Jul 31 2020 09:42 AM - edited Jul 31 2020 09:46 AM
@Akmcg2 IF you are looking for Jan 15th of the next year you can use:
=DATE(YEAR(A1)+1,1,15)
or to avoid weekends etc...
=WORKDAY( DATE(YEAR(A1)+1,1,14),1)
Jul 31 2020 12:52 PM
Jul 31 2020 12:53 PM
Jul 31 2020 01:11 PM
@Akmcg2 I finally get it. There might be a more elegant formula, but this should work:
=IF(DATE(YEAR(K1),MONTH(L3),DAY(L3))>K1,DATE(YEAR(K1),MONTH(L3),DAY(L3)),DATE(YEAR(K1)+1,MONTH(L3),DAY(L3))
Jul 31 2020 01:26 PM
Jul 31 2020 01:54 PM - edited Jul 31 2020 01:56 PM
@Akmcg2 ugh, forgot about that part:
=WORKDAY(DATE(YEAR(K1)+(DATE(YEAR(K1),MONTH(L3),15)<K1),MONTH(L3),14),1)
I even made it a little more elegant, lol.
Jul 31 2020 02:24 PM