Excel Help (Date Formatting)
Discussion
Cheers, it's not quite that simple, should of said first time thru i guess, sorry!
I'm creating a resource chart sort of thing where someone puts in the year and month and it automatically puts the right number of day (numerically) infront of you and also the correct day of the week.
Entering the 1st then drag routine works for days 1 to 28 but it's from there on in that the problem occurs.
Regards
Iain
I'm creating a resource chart sort of thing where someone puts in the year and month and it automatically puts the right number of day (numerically) infront of you and also the correct day of the week.
Entering the 1st then drag routine works for days 1 to 28 but it's from there on in that the problem occurs.
Regards
Iain
I'd say you're over complicating it then
Get them to enter the first day of the month and use a combination of formulas to show all the days/dates for that month
something like this?
DAY DATE
FRI 01-Apr
SAT 02-Apr
SUN 03-Apr
MON 04-Apr
TUE 05-Apr
WED 06-Apr
THU 07-Apr
FRI 08-Apr
SAT 09-Apr
SUN 10-Apr
MON 11-Apr
TUE 12-Apr
WED 13-Apr
THU 14-Apr
FRI 15-Apr
SAT 16-Apr
SUN 17-Apr
MON 18-Apr
TUE 19-Apr
WED 20-Apr
THU 21-Apr
FRI 22-Apr
SAT 23-Apr
SUN 24-Apr
MON 25-Apr
TUE 26-Apr
WED 27-Apr
THU 28-Apr
FRI 29-Apr
SAT 30-Apr
Get them to enter the first day of the month and use a combination of formulas to show all the days/dates for that month
something like this?
DAY DATE
FRI 01-Apr
SAT 02-Apr
SUN 03-Apr
MON 04-Apr
TUE 05-Apr
WED 06-Apr
THU 07-Apr
FRI 08-Apr
SAT 09-Apr
SUN 10-Apr
MON 11-Apr
TUE 12-Apr
WED 13-Apr
THU 14-Apr
FRI 15-Apr
SAT 16-Apr
SUN 17-Apr
MON 18-Apr
TUE 19-Apr
WED 20-Apr
THU 21-Apr
FRI 22-Apr
SAT 23-Apr
SUN 24-Apr
MON 25-Apr
TUE 26-Apr
WED 27-Apr
THU 28-Apr
FRI 29-Apr
SAT 30-Apr
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff