AstroExcel is a spreadsheet, it doesn’t require any special plug-in’s however you will need to enable macros to use the functions. If you are at all concerned please configure your Excel to show the developer tab and then open visual basic from here you can view all the source code.

Latest stable version:


Corrrected Messier RA data


Previous Versions:


Fixes a bug in MoonPhaseDate()


v20151011 adds 2 functions…

RaDec() this calculates the RA and Dec from the Altitude and Azimuth

MoonRise() this calculates the rise, transit and set of the Moon.


10 thoughts on “Download

    1. The reason for this is that I use a ‘quick and very dirty’ hack to find full moon and it is only accurate to 24hrs, it was intended to be a guide only, at the end of the day 24hrs either side of full moon doesn’t make a lot of difference for observing. HOWEVER I am working on a new version of the function that will calculate it more accurately – I just need time to complete it.

      Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s