Search notes:
VBA function: dateAdd
dateAdd(…)
can be used to add intervals to a given point in time:
sub addDateIntervals()
debug.print "Date in a second: " & dateAdd("s" , 1, now)
debug.print "Date in a minute: " & dateAdd("n" , 1, now)
debug.print "Date in a hour: " & dateAdd("h" , 1, now)
debug.print "Date in a week: " & dateAdd("ww" , 1, now)
debug.print "Date in a weekday: " & dateAdd("w" , 1, now)
debug.print "Date in a day: " & dateAdd("d" , 1, now)
debug.print "Date in a month: " & dateAdd("m" , 1, now)
debug.print "Date in a quarter: " & dateAdd("q" , 1, now)
debug.print "Date in a year: " & dateAdd("yyyy", 1, now)
' ? dateAdd("y" , 1, now)
end sub
The following expression evaluates to 2021-02-28:
dateAdd("m", 1, #2021-01-31#)