I need to display a date in a field, this needs to default to the
first of the nearest month, 60 days from todays date.

So in other words for today it should return 01/12/07 (DD/MM/YY).

How would this be done using Excel VBA please?

Thanks!