LinkBack URL
About LinkBacks
I'm making a work schedule by days of the week. Dates are in columns across the top in the mm/dd/yy format. Is there a way to auto populate these fields so that I don't have to keep re-entering new dates?
I'm making a work schedule by days of the week. Dates are in columns across the top in the mm/dd/yy format. Is there a way to auto populate these fields so that I don't have to keep re-entering new dates?
Yes; you could use a formula that advances the dates on some given day of the week.
It would seem for a calendar that might be retained for leter reference that you wouldn't want to do that. And you only need to ever change one date -- the rest can be computed.
Entia non sunt multiplicanda sine necessitate
There is a fill handle (right bottum) of each cell. Dragging it to the right will automatically add 1 (one) and therefore 1 day.
If you would like to add e.g. 7 days then start at A1 (=11/12/2008) and put in A2=A1+7.
Using the fill hanlde (right bottom of the cell A2) and dragging it to the right will add 7 days to every next populated cell.
hope this helps
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
How many dates are there? Are they consecutive?
If you put first date in A1 then in B1 you can use the formula
=A1+1 and drag the formula across as far as you need. Format dates as required.
Now if you change A1 all subsequent dates will change
You could even automate A1 to always show a specific date, i.e. Monday of the current week
=TODAY()-WEEKDAY(TODAY(),3)
If you only want to show weekdays you could change B1 formula to this
=WORKDAY(A1,1)
copied across
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks