'Excel VBA - Do While Loop - Date in a cell
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
Solution 1:[1]
to increase Cells(14,11) within the loop, change that line to
Cells(14,11) = Cells(14,11) + 1
Solution 2:[2]
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
Moving Right One Cell Add one day to date in cells using VBA
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Spencer Barnes |
| Solution 2 | Marc Gomez |