Excel VBA - Do While Loop - Date in a cell

Question

I want to increase the settlement date which is (assigned to cell N13) until the network days (assigned to cell P11) reaches 3.

Network days counts the number of weekdays between two dates excluding holidays. However, I added a range of holidays to it.

Sub Settlement_Date()

Do While Cells(16, 12) < 3
    
    Cells(14,11)
    
Loop

Currently at this stage of the code Sub Settlement_Date() Do While ActiveCell.Offset(0, 3).Value < 3 ActiveCell.Offset(0, -1).Select ActiveCell.Value = ActiveCell.Value + 1 Loop End Sub — Marc Gomez, Apr 21 '22 at 07:22

score 0 · Accepted Answer · answered Apr 21 '22 at 06:48

0

to increase Cells(14,11) within the loop, change that line to

Cells(14,11) = Cells(14,11) + 1

answered Apr 21 '22 at 06:48

Spencer Barnes

score 0 · Answer 2 · answered Apr 21 '22 at 07:40

Managed to do it myself but got snippets in some of the post I found here

Sub Settlement_Date()

Do While ActiveCell.Offset(0, 2).Value < 3 

    ActiveCell.Value = ActiveCell.Value + 1
    
Loop

End Sub

2 Answers2