kerbiloid Posted April 8 Share Posted April 8 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? Quote Link to comment Share on other sites More sharing options...
Jcklemme Posted April 8 Share Posted April 8 (edited) 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 Quote Link to comment Share on other sites More sharing options...
AstroWolfie Posted April 8 Share Posted April 8 How do I make this? Do I copy and paste it into a sheet or what? Quote Link to comment Share on other sites More sharing options...
BA-Forums Posted April 8 Share Posted April 8 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. Quote Link to comment Share on other sites More sharing options...
Jcklemme Posted April 9 Share Posted April 9 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. Quote Link to comment Share on other sites More sharing options...
AstroWolfie Posted April 9 Share Posted April 9 Oh that's all? thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.