vba add a day to a date 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