VBA Get the last day of next month
This is courtesy of Peter Vincent:
He wrote this for an invoicing application he was working on...
Get the last day of next month (VBA)
Get the 1st of 2 months from now and take one day away.
Format(DateAdd("d", -1, Format(DateAdd("m", 2, now()), "1, mmmm, yyyy")), "d, mmmm, yyyy")
He wrote this for an invoicing application he was working on...
Get the last day of next month (VBA)
Get the 1st of 2 months from now and take one day away.
Format(DateAdd("d", -1, Format(DateAdd("m", 2, now()), "1, mmmm, yyyy")), "d, mmmm, yyyy")
posted by Unknown | 5:29 PM
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home