Current mood:	hungry
Current music:	Bob Dylan - Baby Blue

Lifespan Age Calculator Module for Excel Available NOW!!!
I have finished work on the Lifespan Age Calculator Module for Excel, at last! I spent a little while preparing some nice clear instructions for installation and use, packaged the BAS file, the text instruction file and an example implementation in an Excel spreadsheet, all up into a zip file and uploaded it. It's now available for download from the Lifespan Age Calculator homepage.

There are three (3) basic functions :

• LIFESPAN(date, date, int)


• LIFESPANNOW(date, int)


• LIFESPANMANUAL(int, int, int, int, int, int, int)

The LIFESPAN(date, date, int) function is very simple and is probably the one which will be used most often. It has three arguments. The first date is the start date, the second date is the end date and the final int represents which part of the answer you desire returned (eg the months portion of the age, or the years portion).

The LIFESPANNOW(date, int) function is used to calculate the difference between a given starting date and the current system date. The first date is the start date and the int represents the portion of the answer to be returned. eg. 1=Years 2=Months 3=Days.

The LIFESPANMANUAL(int, int, int, int, int, int, int) function is the one that does all the work. The other two functions are just front ends to make this function easier to use. The beauty of this function is that it's not limited by MS serial dates. Everything is done with integers at a painfully low level that I thankfully only have to look at once in a blue moon. There are seven integers as arguments to this function. They comprise two dates and a single integer to represent the portion of the answer required. The start and end date are split into three integers each. One integer for year, month and day in each date.

I know this is a little long winded and not very well thought through but I'm in a bit of a hurry today. Uni starts again soon and I'm late as usual ;) If you have any comments or would like to suggest an improvement, feel free to comment here or drop me a line. Ok, I hope you all like it.