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.
|