Thread
:
Range of Days in a month
View Single Post
#
10
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)
external usenet poster
Posts: 2,202
Range of Days in a month
Here is a slightly shorter formula that can be used in A2 (filled
down to A31)...
A2: =IF((MONTH(IF(A1="",0,A1)+1)=MONTH($A$1)),A1+1,"")
Even shorter...
A2: =IF(MONTH(N(A1)+1)=MONTH($A$1),A1+1,"")
Rick
Reply With Quote
Rick Rothstein \(MVP - VB\)
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)
Range of Days in a month