Subtracting The Today’s Date From Cell Date And Viewing Result In Cell Comment
In this tutorial, we have used the same template again. When the button on userform is clicked , today’s date is subtracted from the date in cell. Result can be viewed on the added comment in cell.
Example : 20.10.2017 – 22.09.2016 (Today’s date) = 393 days
On userform ,days can be calculated until date in cell from today’s date. Related codes :
TextBox15.Value = DateDiff(“d”, Date, Cells(ActiveCell.Row, 1).Value)
If Not IsDate(Cells(ActiveCell.Row, 1)) Then
TextBox15.Value = “Incorrect Value !”