Sat Sun etc

  • Thread starter Thread starter FG
  • Start date Start date
F

FG

Is it possible to set up a spreadsheet to do the following:
You type in Sat (for Saturday) then the rest of the sheet
follows on i.e. Sun Mon Tue Wed etc in the next cells.
Like you are able to with numbers i.e. type in 1 then in
the next cell the sum is "+1" which works for dates as
well.
Thanks.
 
Hi FG
If you type in your first day in say cell A1.
You can then click and drag the bottom right corner of the
cell either across or Down and the cells will populate as
required.
This will also work for numbers but you will need a couple
of them for Excel to understand the squence required.

If you want it to self populate after entering one entry,
I believe you will need code for this.
I'm sure the code answer will be forthcoming from the
users in this NG
Regards
Michael
 
Enter the day names in a list on the worksheet.
Select the cells that contain the day names
Click in the Name Box (to the left of the formula bar)
Type a one-word name for the range, e.g. DayList
Press the Enter key

Type a day name in the starting cell for your calculated list
(cell A3 in this example)
In the cell below, enter the following formula:

=INDEX(DayList,CHOOSE(MATCH(A4,DayList,0),2,3,4,5,6,7,1))

Copy the formula down as far as required.
 
Back
Top