Subtract Day in VBA Code

I need to subtract 1 day from Date Input or where Trade is entered it is date minus 1 day from Date Input.  Thanks in advance.

Trade = Sheets("Date Input").Range("B3")
For row = 1 To ColumnCount

         Sheet1.Cells(List, 2).Value = Trade
Who is Participating?
regmigrantConnect With a Mentor Commented:
If you subtract '1' from a date field Excel will return a date one day earlier than input date - this is default behaviour, what else do you need?

Trade = Sheets("Date Input").Range("B3") - 1
leezacAuthor Commented:
I think that I will just subtract a day from the input date.  Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.