get 3 months later, but ignore year from date cell

[daveyc18]

e2 has 6/20/28 (m/dd/yy)

i want q2 have to 3 months later, but for THIS YEAR (so ignore the in e2) and factoring in the holidays and weekends...

currently i have this in q2

=WORKDAY(EDATE(E2,3)-1,1,holidays)

but this gives me obviously 9/20/28, i want 9/20/23

 

[Fluff]

How about

=WORKDAY(EDATE(DATE(YEAR(TODAY()),MONTH(E2),DAY(E2)),3)-1,1,holidays)

 

[daveyc18]

How about

=WORKDAY(EDATE(DATE(YEAR(TODAY()),MONTH(E2),DAY(E2)),3)-1,1,holidays)

works, tY!

 

[Fluff]

You're welcome & thanks for the feedback.