|
下面代码,如果Range("A2")值是2015年12月28日时,s= 13月.xlsx",怎样使结果是1月.xlsx",请帮忙
Public Sub SDD()
If Day(Range("A2")) < 25 Then
s = Month(Range("A2")) & "月.xlsx"
Else
s= Month(Range("A2")) + 1 & "月.xlsx"
End If
End Sub
Public Sub SDD()
Dim rng, m, d
Set rng = Range("A2")
m = Month(rng)
d = Day(rng)
m = IIf(d < 25, m, m + 1)
m = IIf(m Mod 12, m Mod 12, m)
MsgBox m & "月.xlsx"
End Sub
|
|