In Need of Help with an Excel Formula.

I am not Excel literate when it comes to formulas, I can change text - colour - add borders - wrap text etc., the basic things.

I have an excel spreadsheet in which I want to be able to select column B2 - B5, then use the Fill Handle to fill the column.
The date column alters by 2 days - then 5 days and continues to cycle in that manner as you use the Fill Handle. The picture below shows what I am trying to accomplish, the next date in the sequence would be Mon 20/01/2025.

Thanks.

Could somebody help me with a formula that will enable me to do that.

I suggest to ask chatgpt. It's very good at this sort of question.

Enter 6th Jan in A1

In A2, enter =A1 + IF(WEEKDAY(A1,2)=1, 2, 5)

copy this formula to all the cells where you need the dates.

If you hover over the bottom-right-hand corner of A2 until the cursor turns into a +, you can just drag down as far as needed.

kelper said:

Enter 6th Jan in A1

In A2, enter =A1 + IF(WEEKDAY(A1,2)=1, 2, 5)

copy this formula to all the cells where you need the dates.

If you hover over the bottom-right-hand corner of A2 until the cursor turns into a +, you can just drag down as far as needed.

Click to expand...

You beat me to it !!!

Cheers
jimbo

I did ask ChatGPT for this, but his first attempt did not work.

Thanks for your help Kelper & jimbo45.
Your formula makes it much easier for me, when entering the dates in Excel for a whole year.
The reason it is Mon & Wed, is because they are the days my mate & I play golf.