Macro/Formula to skip or omit values from weekends to just weekdays.

Hi,

I have been trying hard but I can't figure out on how to rearrange a list of values to skip or omit weekends to just weekdays.

Please refer to the attached file, from the "Original" tab to the "Desired" tab.

Can anyone help?

Regards.

escapes_example.xlsx

Hi,

try this formula in C2 and copy down.
=IF(A2="Saturday","",IF(A2="Sunday","",B2))

Hi,

Thank you for your reply.

I need the same set of values from "Saturday" & "Sunday" to populate on the next following "Monday" & "Tuesdays" onwards. Not just "blanks".

Not sure if this is possible.

Try running this macro when the active sheet is the original sheet. It will populate column C.

Please note that the macro assumes that the first day in A2 cell is Monday. If it isn't, insert one or more rows so that it starts with Monday and add dummy data.

Please Login or Register  to view this content.

Hi!

Thank you, I finally see some light that it can be possible.

The macro you provided omits the last value in "B:B" when populating to "C:C".

Regards.

Glad it works. I think it will include the last value if you change this line

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Thank you!