How do I count down the days till next payday if one is paid on the second Wednesday of every month?
I can get the second Wednesday date by using:
=WORKDAY.INTL(EOMONTH(F11,0),2,"1101111")
But I don’t know to use it with using it in the following:
=DATEDIF(NOW(),**??**, "d") & " days till payday"
or is there a better/easier way?
Thanks for any solutions or suggestions.
← Next month second Wednesday date error
no rocket science :
=DATEDIF(TODAY(), WORKDAY.INTL(EOMONTH(F11,0),2,"1101111") , "d") & " days till payday"
let =WORDAY ... in a separate column
Using your =DATEIF… function, I get a “#NAME?” error. What did I do wrong here.
Days_till_Next_Payday.ods (14.8 KB)
the double quotes – copied from your first post 
PKG,
Thank you. It works fine.