excel macro use DateAdd in formula code example
Example: excel vba add one hour
'To add an hour to a date or time value in Excel...
'As a worksheet formula:
=A1 + 1/24
'And it works in VBA as well:
MsgBox Now + 1/24
'To add an hour to a date or time value in Excel...
'As a worksheet formula:
=A1 + 1/24
'And it works in VBA as well:
MsgBox Now + 1/24