# The 15th of every month and use following workday

Experts, I need a formula I can drag down that will give me the 15th of every month and use the following (not preceding) day if the 15 lands on a holiday or a weekend.  It would be something similar to the below but this addes 15 workdays to a date.

=WORKDAY(EOMONTH(H865,MOD(12-MONTH(H865),1)),15,Holidays_US_Jap)

thank you
###### Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x

Commented:
Rgonzo's formula works if you just add +1 to the MONTH part, i.e.

=WORKDAY(DATE(YEAR(H865),MONTH(H865)+1,14),1,Holidays_US_Jap)

....or you can use EOMONTH for the same result with a slightly shorter formula

=WORKDAY(EOMONTH(H865,0)+14,1,Holidays_US_Jap)

regards, barry
0

Commented:
Hi,

pls try

=WORKDAY(DATE(YEAR(H865),MONTH(H865),14),1,Holidays_US_Jap)

Regards
0

Project financeAuthor Commented:
Hi, I dont think that is the solution.  If you drag that formula down, the date repeats and doesnt change to the next month.