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
pdvsaProject financeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
barry houdiniConnect With a Mentor 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
 
Rgonzo1971Commented:
Hi,

pls try

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

Regards
0
 
pdvsaProject 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.

Follow me?

thank you
0
 
pdvsaProject financeAuthor Commented:
thank you Barry...
0
All Courses

From novice to tech pro — start learning today.