View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default labor day holiday formula

Since Labor day fall on the first Monday in September and I'm using this
formula to calculate the last Monday in May for Memorial day. How can I write
a new formula for September?
=NDOW(TheYear, 5,DowsInMonth(TheYear,5,2), 2)
Thanks in advance!!!