I am trying to get a work sheet to put days in automatically i.e if A1 has mon cell a2 has tues etc for 28 cells I know I can do a if command but each month will have a different starting day ex I need A1 to be a sun and there for need it to calculate A2 etc from mon all help appreciated
Put the date of the first day of the month in A1 and apply a custom filter to that cell of "ddd".
Then put this formula in A2:
=A1+1
and apply the same format to that. Then copy A2 down to A28.
Hope this helps.
Pete
EDIT: if you want to change the month, all you need to do is to put the date for the first of that month in A1, and the rest of the cells will change automatically.
Last edited by Pete_UK; 07-18-2012 at 12:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks