Excel project: weekly calendar Aug04 '04

# (1 of 5): Cameron

1 year, 9 months after the fact. (Wed 03 May 2006, 12:53 PM CST)

1)With B4 being the first date of your schedule, in c4 use =b4 1 for the date,drag to copy for the rest of the week...now you only have to input the starting date and the rest will follow.

2) to populate the corresponding day above the date...
B3 would =text(b4,"DDD"). Click and drag across to copy.

done easy, no brain racking conditionals to worry about and problem solved.

# (2 of 5): Imran Anjum

2 years, 7 months after the fact. (Fri 30 Mar 2007, 2:04 AM CST)

Please send me the themplate of fWeekly calender for year 2007.

Previous comment Return to entry

# (3 of 5): Tom

2 years, 10 months after the fact. (Sat 09 Jun 2007, 9:14 AM CST)

your logic seek repeated itself in the formula. 1 check = 2 check greater 3 check less than

it has only 3 outcome so if not = and greater, must be less than it is more clear in the following =if (weekday=2,today(),if(2

Previous comment Return to entry

# (4 of 5): Tom

2 years, 10 months after the fact. (Sun 10 Jun 2007, 7:41 AM CST)

If use array, it will be easy, define an array 1 to 7 across, call it weekday, then the array formula will be =today()-weekday(today())+weekday

Previous comment Return to entry

# (5 of 5): Tom

2 years, 10 months after the fact. (Sun 10 Jun 2007, 8:02 AM CST)

if you dont feel comfortable of array, the idea is move back the today date to the end of previous week, then add 1,2 ...7 to the corresponding weekday, if e.g. monday is 2,then today-2 is the date of the end of last week,then add 1 on sunday, add 2 on tuesday...add 7 on saturday. anyone can write the easy formula.

Previous comment Return to entry