Hi Sandy
It works fine until A1 contains either the 30th or 31st of a month, when it
give the 10th of the month two months hence.
--
Regards
Roger Govier
"Sandy Mann" wrote in message
...
Just another way:
=A1+33-DAY(A1+33)+10
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Statesman" wrote in message
...
From a "start date" in current month; I want to return a billing due date
to
always be the 10th of the following month.