Skip to main content
We’ve updated our Terms of Service. A new AI Addendum clarifies how Stack Overflow utilizes AI interactions.
Code Golf

Return to Answer

Commonmark migration
Source Link

#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.

deleted 5 characters in body
Source Link
willuwontu
  • 351
  • 3
  • 9

#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.

added 3 characters in body
Source Link
willuwontu
  • 351
  • 3
  • 9

#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.

Source Link
willuwontu
  • 351
  • 3
  • 9
Loading

AltStyle によって変換されたページ (->オリジナル) /