September 27, 2009OK gang... i consider myself pretty good at excel but my aunt just asked me one that i am having trouble figuring out.
She makes calanders for work... the colums go from 1 - 31 or however many days in the month
the row above the numbers shows the days
m t w th f sat sun etc....
what she wants to do is set it up for one month, then just load the first column with what day it is and let it fill in the rest of the days after that... for the next month so it does not require her to set it up each time.... there has got to be a formula for that or something - i cant figure it out
any help is appreciated