View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default How do i fill in cells according to date

I'm having a little difficulty visualizing the format of your sprdsht,
but: you should be able to use the WEEKDAY function in conjunction with
conditional formatting to do what you need. WEEKDAY returns an integer
number from 1 to 7 representing the day in the week for a given date.