Autofill Weekdays With Numeric Date Also

**GeorgeJefferson** · 03-11-2010, 10:23 AM

Hello,

I'm trying to create a spreadsheet that will have row 1 columns A-Infinity filled as follows:

Monday, 3/15/10 | Tuesday 3/16/10 | Wednesday, 3/17/10 | Thursday, 3/18/10 | Friday 3/19/10

This with each day of the week Mon-Fri with that date figured in a column of its own.

I am unable to find a way to make this autofill for each week to avoid having to manually do it.

Can anyone help?

I would like to show Mon-Fri and the numeric date for each day of the week and start with Mon-Fri the next week and so on to infinity.

**NBVC** · 03-11-2010, 10:31 AM

If you enter the start date in a1, then in A2:

=A1+IF(WEEKDAY(A1+1,2)=6,3,1)

copied down as far as you want

Format the Column as custom: dddd, m/dd/yy

**johncena** · 03-11-2010, 10:33 AM

not clear your question for me.but format cell --> date then u can see lot of format's are there.but your format not there.if u like u can use this format..

Thursday, March 11, 2010

...

**GeorgeJefferson** · 03-11-2010, 11:06 AM

Originally Posted by NBVC

If you enter the start date in a1, then in A2:

=A1+IF(WEEKDAY(A1+1,2)=6,3,1)

copied down as far as you want

Format the Column as custom: dddd, m/dd/yy

I am listing my dates horizontally across row 1.

So far this is working to give me the numeric date in order which is awesome, I'd love however to work in the weekday Mon-Fri also.

**NBVC** · 03-11-2010, 11:10 AM

Merged cells don't work with dragging a formula.. you will have to unmerge...

This does only display M-F dates, not weekends.. as you drag it down or across...

given start date located in A1.

Remember that you have to format the cells after, as per above custom format... to get the dates to show as you desire....