Excel Lotto Checker Spreadsheets Added For Missouri, New Jersey & Virginia Lottos

I've just added some lotto checkers for the Missouri Lotto, New Jersey Lotto and the Virginia Win For Life Lotto. All are available in basic and premium formats. For more information click the links below...

US Missouri Lotto Checker
US New Jersey Lotto Checker
US Virginia Win For Life Lotto Checker

Hot Lotto & Texas Lotto Checker Spreadsheets Added

I've just added some lotto checkers for the American Hot Lotto and Texas Lotto. Both are available in basic and premium formats. For more information click the links below...

US Hot Lotto Checker
US Texas Lotto Checker

South African Lotto Checker Spreadsheets Added

I've added some new lotto checker files which allow you to check your results for the South African Lotto, Lotto Plus & Powerball draws.

For more details check out:
Lotto
Lotto Plus
Powerball

EOMONTH Problem And Alternative

I've recently had problems with files using the EOMONTH function in 2007. Files with the function in sometimes come up with the following warning message:



Once the file opens the cell with the EOMONTH function in just displays =#N/A
As a result I've created the following function to replace the EOMONTH function. The function uses the same criteria as EOMONTH but uses the word Lastday. The function is used like =Lastday(start_date,months)

Function Lastday(datex As Date, mthpls As Integer)

mthpls = mthpls + 1
yr = Year(datex)
mth = Month(datex) + mthpls
dy = Day(datex)

Lastday = Format(DateSerial(yr, mth, dy) - 1, "Short Date")

End Function

It's not fully tested so if you decide to use it and find a problem let me know.

EuroMillions £90 Million - Learn The Secrets!

This weeks EuroMillions jackpot is a massive £90 million! If you want to find out what numbers have been drawn the most or how many odd/even numbers have come out then now's the time to buy the Spreadsheets Direct EuroMillions Checker. The EuroMillions checker also lets you quickly and easily check either a single line, showing you all the times those have won in the past, or multiple lines against each draw letting you see quickly what lines have won.

Buy yours today and see if it makes you rich!

Advertise Your Business Virally With Excel Quizzes

Spending loads on Adwords without much return?

Need to get people to know about your new business?

Want a new way to advertise your business or goods?

Then why not try advertising on

Spreadsheets Direct's Excel quizzes!

How many times have you been sent an Excel quiz by someone you know? If one person in an office downloads a quiz the likelihood is that they will send it on to another 4 or 5 people who in turn will forward it on to their own mates in other offices. A single downloaded quiz could end up on 100 computers in hours and all those people could be looking at your advert!

Spreadsheets Direct's Excel quizzes are currently downloaded around 1000 times a month with new quizzes being added all the time. Current quizzes cover a range of topics including movies, music, television and sport.

Spreadsheets Direct is now offering you the chance to place an image advert or text link on the left hand side of the quizzes starting from just £2.50 a month! Adverts can be linked directly to any page you desire. An added bonus is that, even if you decide not to renew advertising on a quiz, any versions of the quiz that are out there with your advert on will still be showing your advert and could still be being sent round virally giving you click-thrus for a long time to come!

For more information see Advertising Info

Excel Quiz Templates Available To Download

Have you got a quiz you want to share? Download a template here.

1 Answer Template Download

2 Answer Template Download

Send to quizzes@spreadsheetsdirect.com and I'll add them to excelquizzes.blogspot.com so that others can download them.