Auto-Fill Weekdays Across Multiple Worksheets

[hudtwalcker]

I have a worksheet with 31 sheets (one for each day of a month). I would like cell D2 to auto-fill the weekday that corresponds with the sheet. For example, if D2 of Sheet 1 is Thursday, I need Sheets 2-31 to display the rest of days respectively.

I have very little experience with formulas.

Thank you so much !!

[Pete_UK]

How are your sheets named? Are they just 1, 2, 3 etc., or do you have a simplified date like Aug-1, Aug-2 etc.?

It would be possible to have a formula in D2 of each sheet which picks up the sheet name (using the CELL function) and then converts it into the appropriate date for that month. Does the name of the file include something which identifies the month and year?

More details needed, please.

Pete

[hudtwalcker]

My sheets are named 1-31, on D2 on every sheet is where I place the day of the week, like for example August will start on a Thursday, so I whrite Thursday, I need the same D2 cell on the rest of the pages (2-31) to auto-fill accordingly, yes each file identifies the month and year, so I just have 12 files for the whole year and each file has 31 days, I already got the formula for doing what I need with the date, now I just need the formula for the weekdays, thnx !Attachment 635136

[Pete_UK]

I can't open your attachment.

If you already have the date in a cell, then you can just reference that cell (e.g. = B2, if B2 contains the date), and then format the cell with the formula in using a Custom Format of:

dddd

Hope this helps.

Pete

[Pete_UK]

Incidentally, if you want to attach a file then do this:

click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

[hudtwalcker]

Incidentally, if you want to attach a file then do this:

click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Here's the screenshot of my sheet, thnx

[hudtwalcker]

As you can see from the screenshot, on cell D2 is says "Thursday" what I need is to write that down and for page 2 to say "friday" page 3 "saturday" page 4 "sunday" page 5 "monday" and so on...

[Pete_UK]

You should group all the sheets from 1 to 31, by selecting tab 1, hold down the SHIFT key, and then select tab 31. Now everything that you do to one sheet will be reflected into all the other sheets at the same time.

Firstly, you can select cell D2 and put this formula in:

=D3

Select cell D2 again, and right-click and select Format cells from the drop-down, choose Custom Format on the Number tab and enter this format:

dddd

Click OK, and now you must ungroup the sheets - right-click on a sheet tab and choose Ungroup sheets, and then you are done.

This assumes that cell D3 in each sheet contains the appropriate date (I can't see that from a single screen-shot).

Hope this helps.

Pete

EDIT: You do not now have to enter anything for the day - the formula will derive it for you automatically.

[hudtwalcker]

Perfect THANK YOU !! That's exactly what I needed !! you helped me out a lot !!

[Pete_UK]

Glad to be of help - thanks for the rep.

Pete