finding the date 3 months later, 6 months later, and 12 months later

[daveyc18]

please help

im trying to find the date 3 months later, 6 months later, etc.....taking into account working/business days only ....i already have a table set up for holidays

 

[Repush]

quite hideous . . but is does the trick I think

=EDATE(A1,[COLOR=#ff0000][I][B]3[/B][/I][/COLOR])+IF(8-WEEKDAY(EDATE(A1,[COLOR=#ff0000][B][I]3[/I][/B][/COLOR]),2)<3,8-WEEKDAY(EDATE(A1,[B][I][COLOR=#ff0000]3[/COLOR][/I][/B]),2),0)

change the red 3's to 6, 9, 12
just check against holidays

 

[steve the fish]

You could use workday:

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