#Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1)*7)
Next y,x
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1)*7)
Next y,x
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1)*7)
Next y,x
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1*71)
Next*7)
Next y,x
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1*7)
Next
Next
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1)*7)
Next y,x
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, 190(削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v = DateValuev=DateValue(i)-17
For x = 1 Tox=1To 5
For y = 0 Toy=0To 6
d(0,y) = Left=Left(WeekdayName(Weekday(v + yv+y)),2)
d(x,y) = day=day(v + y + v+y+(x- 1) * 71*7)
Next
Next
z = dz=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, 190 bytes
Function z(i)
Dim d(5,6)
v = DateValue(i)-17
For x = 1 To 5
For y = 0 To 6
d(0,y) = Left(WeekdayName(Weekday(v + y)),2)
d(x,y) = day(v + y + (x- 1) * 7)
Next
Next
z = d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.
#Excel VBA, (削除) 190 (削除ここまで) 159 bytes
Thanks @TaylorScott
Function z(i)
Dim d(5,6)
v=DateValue(i)-17
For x=1To 5
For y=0To 6
d(0,y)=Left(WeekdayName(Weekday(v+y)),2)
d(x,y)=day(v+y+(x-1*7)
Next
Next
z=d()
End Function
Takes input in the form of a valid date string for Excel VBA (e.g. February 19, 2020; 2/19/2020; 19-Feb-2019), and returns an array with the given calendar centered on it.