View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_2_] Roger Govier[_2_] is offline
external usenet poster
 
Posts: 57
Default How do I return the 10th day of the following month?

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.