Excel Vba Subtracting Date From Cell Date

September 22, 2016 2 comments

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

Download Example Workbook

Excel Vba Calculating Days Between Date In Cell And Today

September 21, 2016 Leave a comment

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 !”
End If

Download Example Workbook