Finding the nth day of a month

[dpaton05]

How can I find the date of the nth day of a month such as the 10th day of the month using vba and using a excel formula?

 

[Joe4]

Assuming you mean the current month, in native Excel formula, there are a few different ways:

=DATE(YEAR(TODAY()),MONTH(TODAY()),10)

or

=TODAY()-DAY(TODAY())+10

In VBA, it is very similar, except you use the DATESERIAL function instead of DATE, and use DATE instead of TODAY().
I will leave it to you to do that substitution (in the first formula above).