Code to evaluate a column of dates and change any dates that fall on weekends.

**dollarbill1979** · 01-21-2021, 09:09 PM

As the title states, i have a column of dates provided by another program. I would like to run a code that will go through that column and automatically change any dates that fall on weekends to the next working day. Thank you in advance.

**XLent** · 01-22-2021, 06:05 AM

You can use WORKDAY, so something like

Please Login or Register  to view this content.

modify sheet and column reference as appropriate

Code to evaluate a column of dates and change any dates that fall on weekends.

LinkBack

Thread Tools

Rate This Thread

Display

Code to evaluate a column of dates and change any dates that fall on weekends.

Re: Code to evaluate a column of dates and change any dates that fall on weekends.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to skip custom dates and weekends

[SOLVED] have list of dates, need how many of those dates fall between two other dates, monthly rpt

[SOLVED] Averaging values if desired dates fall between range of dates

Average column when dates fall between x and y

Need Sumif to count dates that fall within a range of dates

Macro to change dates (while skipping weekends)

[SOLVED] Calculating number of days between two dates that fall between two other dates

Bookmarks

Bookmarks

Posting Permissions