Jump to content

Stargazers Lounge Uses Cookies

Like most websites, SGL uses cookies in order to deliver a secure, personalised service, to provide social media functions and to analyse our traffic. Continued use of SGL indicates your acceptance of our cookie policy.

sgl_imaging_challenge_banner_dslr_mirrorlesss_winners.thumb.jpg.9deb4a8db27e7485a7bb99d98667c94e.jpg

AndyWB

Calculating the day of the lunar cycle...

Recommended Posts

Okay, I figure this should be easy, but when I try Googling I get endless articles about figuring out when Easter is, or the Chinese calendar, or various other religious reasons.

I've a spreadsheet with all my observations in it. Each row has a date. I'd like to be able to resolve that date, roughly, to the day in the lunar month.

e.g. 21/02/2015 > 7

It's only rough, so I'm hoping things like it's elliptical orbit, etc., can be ignored.

Has anyone come across a simple formula for something like that?

Share this post


Link to post
Share on other sites

Try moongiant.com. Might be what you're looking for, or help.

Share this post


Link to post
Share on other sites

Do you mean something like this   :

The formulas are in Norwegian so you have to change :

REST with  MOD     ( I think..)

HVIS  with IF          ( leaves empty cell if date not entered, if not you will end up with 29 in every cell)

Lunar day coloumn  has to be formatted as number, no decimals)

Copy and paste from c6 and down...

PS I have no idea wether u use ";" or "," in UK (within the formulas)

PS2 : Havent checked it for bugs or errors....

post-35549-0-76814000-1433292759.jpg

Edited by Pondus
  • Like 1

Share this post


Link to post
Share on other sites

Of course you have "phases of the moon" app for android, and numerous other possibilities, but I was

under the impression that you wanted lunar days implemented in a spreadsheet => enter date, and lunar day calculates automatic.

Rune

Share this post


Link to post
Share on other sites

Yep, that's exactly what I was after, Pondus, and it seems to work. I wondered if there was a correlation between the point in the lunar cycle, and when I'd go out observing. It seemed I should be able to calculate that!

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.