how can i copy group of cells in same fill eg 16/06/2023, 18/6/23, 23/6/23, 25/6/23? i want every friday and sunday dates for a year

Question

how can i copy group of cells in same fill eg 16/06/2023, 18/6/23, 23/6/23, 25/6/23? i want every friday and sunday dates for a year

Anonymous

in excel how can i copy group of cells in same fill eg 16/06/2023, 18/6/23, 23/6/23, 25/6/23? i want every friday and sunday dates for a year

my version of excel is:

Microsoft® Excel® for Microsoft 365 MSO (Version 2505 Build 16.0.18827.20092) 64-bit

EndFragment

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

2 additional answers

Answer 1

Ashish Mathur 100.2K Volunteer Moderator

You are welcome. If my reply helped, please mark the previous reply as Answer.

Answer 2

Put the year in cell A1 and in an other cell apply below formula:

=LET(y, A1, wd, UNIQUE(WORKDAY.INTL(DATE(y, 0, SEQUENCE(400,, 1)), 2, "1111010")), FILTER(wd, YEAR(wd) = y))

This formula returns any date of the year that falls on a Friday and a Sunday.

Format the cells as dates.

HTH

Answer 3

Ashish Mathur 100.2K Volunteer Moderator

Hi,

In cell B4, enter this formula

=WORKDAY.INTL(DATE($B$1,1,1),SEQUENCE(10),"1111010")

Format the resultant cells as dates. Ensure that all cells below cell B4 are empty. Type 2025 in cell B1.

Hope this helps.

Answer 4

Anonymous

thanks

Answer 5

Anonymous

thanks

Share via

how can i copy group of cells in same fill eg 16/06/2023, 18/6/23, 23/6/23, 25/6/23? i want every friday and sunday dates for a year

2 additional answers