"Arvi Laanemets" wrote in message
...

Somewhat shorter version:
=DAY(Date(year(target date), month( target date)+1, 0))

and if you can guarantee that target date will never be later than the 28th
then

=DAY(A14+32-DAY(A14+32))

is shorter still, otherwise

=DAY(A14-DAY(A14)+32-DAY(A14-DAY(A14)+32))

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk