excel help

Associate
Joined
17 Aug 2005
Posts
1,756
Location
Gloucester, UK
hey all, trying to help out me mum , she is doing staff rotas at work. now i can do a few things in excel (far from knowing much!) . just wondering if there is a quick way.

what i want to do is :

coloum 1 coloum 2

1st monday
2nd tues

etc etc

now i know this will change each month, so is there a way to calculate what days etc corrospond by just putting in what month and year it is. so it automaticly does coloum 1 and 2?

right hope i explained that right, confusing myself!
 
Back
Top Bottom