automatically putting in dates like tuesday/thursday

John

unread,

May 15, 2003, 8:53:39 AM5/15/03

to

or Monday Wednesday...

if i enter a date in one cell and then drag the cell it
will want to enter dates sequentially...but there must be
some easy way to enter a different pattern...

help! thanks in advance!

:)

Mike Tomasura

unread,

May 15, 2003, 9:18:55 AM5/15/03

to

I'm sure there is an easy way. But here is one way.

Just paste this formula into a cell then copy the cell across the columns.

=IF(A1="Monday","Tuesday",IF(A1="Tuesday","Wednesday",IF(A1="Wednesday","Thu
rsday",IF(A1="Thursday","Friday",IF(A1="Friday","Saturday",IF(A1="Saturday",
"Sunday",IF(A1="Sunday","Monday","Monday")))))))

John <wilj...@nospam.com> wrote in message
news:055901c31ae1$01e56340$a001...@phx.gbl...

Jason Morin

unread,

May 15, 2003, 9:42:56 AM5/15/03

to

Type in the date (like 5/12/03) in A1. In A2 put =A1+2.
Now fill A2 down. Custom format col. A as dddd.

HTH
Jason
Atlanta, GA

>.
>

Mike Scobie

unread,

May 15, 2003, 9:51:07 AM5/15/03

to

Go to Tools > Options 'Custom Lists' tab. You can import
your new list from a worksheet range.

Mike

>.
>

Myrna Larson

unread,

May 15, 2003, 3:19:23 PM5/15/03

to

What pattern do you want? Just Tues and Thurs every week? Excel can't handle that with automatic
incrementing since the increment is 2, 5, 2, 5, etc.

You can do it with a formula:

Put the first date (a Tue or Thu) in A1. In A2

=A1+IF(WEEKDAY(A1)=3,2,5)

and copy down.

Myrna Larson

unread,

May 15, 2003, 3:25:48 PM5/15/03

to

If you want just every other day, then you can enter the 1st 2 dates, select those cells, and
drag the fill handle.

I thought he wanted only Tuesdays and Thursdays. Just adding 2 will give
Tue-Thu-Sat-Mon-Wed-Fri. Maybe I misinterpreted his post...

john

unread,

May 16, 2003, 7:32:29 AM5/16/03

to

yes i need to do monday and wednesday or tuesday and
thursday for 15 weeks (a semester--to track attendance)
thanks again!

:)

>.
>

gck...@gmail.com

unread,

Mar 26, 2015, 10:51:54 AM3/26/15

to

Myrna,

Thank you!!! Your formula worked perfectly for what I needed, using Sheet1's cell B1 as the start date.

However, I am now trying to exclude specific dates calculated in my Sheet2's cells A3:A12, and I'm having trouble joining the two calculations. I've looked online, but all other topics discuss excluding weekends and don't take into account the WEEKDAY formula for Tuesdays/Thursdays.

Help! :|

Best,
Gaby

lyzett...@gmail.com

unread,

Jan 26, 2017, 3:07:32 PM1/26/17

to

This was incredibly helpful! Thank you so much!!

rn...@ualberta.ca

unread,

Dec 23, 2019, 12:37:49 PM12/23/19

to

This was very helpful, thank you! :)

Message has been deleted

Katrina Garcia

unread,

Apr 30, 2023, 12:27:06 AM4/30/23

to

Myrna,

Your formula worked! Thank you!

Lorenzo Casanova

unread,

Jul 3, 2023, 8:48:16 PM7/3/23

to

Hello, I'm trying to copy the formula for Tuesday and Thursday. I'm not having any luck. I'm looking to start my student roster on cell/D1 on 8/22/2023 and cell/E1 8/24/2023. I need help placing these days into an attendance sheet.