Jump to content

Kerbal Calendar


Superfluous J

Recommended Posts

 

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

image.png

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 by Jcklemme
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 1 month later...
This thread is quite old. Please consider starting a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...