Thread: How do I return the 10th day of the following month?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do I return the 10th day of the following month?
=DATE(YEAR(A1),MONTH(A1)+1,10)

"Statesman" wrote:

From a "start date" in current month; I want to return a billing due date to
always be the 10th of the following month.
Reply With QuoteReply With Quote