Kerbal Calendar

[kerbiloid]

2 hours ago, BA-Forums said:

is there a day where the Kerbals just eat snacks?

that is all i need to know.

Do you want the ammonia-rich Kerbal snacks? Why should they?

[Jcklemme]

 

Spoiler

=IF(OR(ISBLANK(I2), ISBLANK(J2)), "", 
  LET(
    year, 1960 + I2,
    dayOfYear, J2,
    monthName, 
      IF(dayOfYear <= 56, "Launchuary", 
      IF(dayOfYear <= 112, "Feblast", 
      IF(dayOfYear <= 168, "Sprorbit",
      IF(dayOfYear <= 224, "Mayday",
      IF(dayOfYear <= 280, "Jebedune",
      IF(dayOfYear <= 336, "Jooly",
      IF(dayOfYear <= 392, "Astronautumn",
      IF(dayOfYear <= 426, "Docktober", 
      "Error")))))))),
    dayOfMonth, 
      IF(dayOfYear <= 56, dayOfYear, 
      IF(dayOfYear <= 112, dayOfYear - 56, 
      IF(dayOfYear <= 168, dayOfYear - 112,
      IF(dayOfYear <= 224, dayOfYear - 168,
      IF(dayOfYear <= 280, dayOfYear - 224,
      IF(dayOfYear <= 336, dayOfYear - 280,
      IF(dayOfYear <= 392, dayOfYear - 336,
      IF(dayOfYear <= 426, dayOfYear - 392, 
      dayOfYear)))))))),
    monthName & " " & dayOfMonth & ", " & year
  )
)

 

I wrote a Google Sheets function that lets you put the Year and Day into a cell and then this will display the Kerbin Date. 

Replace I2 (year) & J2 (day) with the cells you'd actually like to reference.  The calendar starts in 1961 but you can easily change that.  Rename the months as desired.  This uses the OP calendar, but can easily be modified to use other days of the week.  Please not that this does not include leap years, as I don't need to use them for what I'm using this for.  If there was a strong desire for leap years being figured I could possibly work on writing that up, but as it stands I don't feel the need to figure that here.

Here's how it would look implemented in a sheet:

Spoiler

I like to group the Year and Day column so they can be hidden and shown easily.

I don't think anyone actually wanted it but I made it so I figured I'd share.

Edited April 8 by Jcklemme

[AstroWolfie]

How do I make this? Do I copy and paste it into a sheet or what?

[BA-Forums]

4 hours ago, kerbiloid said:

Do you want the ammonia-rich Kerbal snacks? Why should they?

Yes, i want the ammonia-rich Kerbal snacks. The kerbals love snacks, that is why. Maybe it could be a holiday or something.

[Jcklemme]

4 hours ago, AstroWolfie said:

How do I make this? Do I copy and paste it into a sheet or what?

Copy the "code" and paste it into the entry field for a cell.  Let me know if there's more you need on this.

[AstroWolfie]

Oh that's all?

thanks!

[Iapetus7342]

Here's a good video on this topic by @MythicalHeFF