Need Date formula that Produces Date from Day of the Week

[jmnicole]

Good Morning,

I am new here and am in desperate need of help with a formula. I work a two week DAY SHIFT schedule based on a rotation of days with the Sheriff's Dept. For example I start a new rotation on Monday. I work Monday, Tuesday, Friday, Saturday, Sunday and then Wednesday Thursday. I want to list the days of week and be able to populate the date for the day of the week based on a cell that has the beginning Monday's date. After the day shift 2 week rotation I then work the same days on a 2 week NIGHT SHIFT schedule. Any help is greatly appreciated.

[Bob Phillips]

Assuming that your Monday start date is in A2, put this formula in A3 and copy down to A8

=A2+INDEX({1,3,1,1,3,1},ROW(A1))

[jmnicole]

this is what it looks like

A-Platoon
NIGHT SHIFT
WEEK OF
03/26/12

MONDAY TUESDAY FRIDAY SATURDAY SUNDAY WEDNESDAY THURSDAY
03/26/12

[Bob Phillips]

Change it to

=A7+INDEX({1,3,1,1,3,1},COLUMN(A1))

[rvasquez]

Hello there,

Attached is a workbook I created. It allows you to select the schedule and will show that day and dates for your current schedule.

Thanks!

[jmnicole]

what is wrong with the following?:

=IF(C6=K2,(B4+1))


C6=day of week I work
K2= validation day of week
B4= Monday's Date
B4+1 should equal Tuesday's Date but all I get is #value!