Thread: global user-defined name (range) - or help with holidays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
  
Posts: 1,182
Default global user-defined name (range) - or help with holidays
Matthew,
I like to avoid using global scope names as much as possible for many
reasons. If you want to ref local scope names from another sheet...

=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(WO RKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY( ))-1),1))15),16),-1,sheet1!holidays)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Reply With QuoteReply With Quote