Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Not open for further replies.
1 - 2 of 2 Posts

8 Posts
Discussion Starter · #1 ·
Here is my challenge.

I have a table representing Demand employees on various dates for "AM" shifts, and "PM" shifts.

23/1/10 24/1/10 25/1/10 26/1/10 27/1/10
Demand AM 5 5 5 5 15
Demand PM 5 5 5 5 15

Below this I have a list of names followed by the shift they are working, and the date.

Volunteer Name Shift Shift Date
Frank PM 23/01/2010
Allice AM 24/01/2010
Brandon PM 25/01/2010
Craig AM 26/01/2010

What I need is a formula that will subtract 1 from the demand total of either Demand AM or Demand PM when "AM" or "PM" is entered in these cells corresponding to the date. Any ideas? Help me!


1 - 2 of 2 Posts
Not open for further replies.