View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jenn k jenn k is offline
external usenet poster
 
Posts: 4
Default newbie trouble with formula

Hi all..could you please help me with the following formula?
=if(weekday(B2-1)=1,B2-3,B2-1)
B2 is 7/31/2008. I'm very new at excel, please forgive my lack of
knowledge. Thanks!
--
jenn k