Newsletter Subject

Semimonthly pay dates & VBA School

From

exceljet.net

Email Address

contact@exceljet.net

Sent On

Fri, Sep 15, 2023 01:07 PM

Email Preheader Text

Hi - Dave here. Happy Friday! In my last few emails, I've shared some formulas that generate lists o

Hi - Dave here. Happy Friday! In my last few emails, I've shared some formulas that generate lists of dates, generally using a combination of the SEQUENCE function and the WORKDAY.INTL function. This week, I want to share a more advanced formula to list semimonthly pay dates. A semimonthly pay schedule means employees are paid twice a month, usually on the 1st and 15th or the 15th and the last day of the month. This is a bit tricky to do with an Excel formula, but it can be done! You can see what this looks like in the worksheet below, where we use the SEQUENCE function to generate dates, and the FILTER function to find pay dates that fall on the 1st and 15th for the first half of a year: [Formula for semimonthly pay dates]( [[Download the workbook and read the full explanation](] Note we are also using the LET function to avoid redundancy and make the formula easier to read. Click the link above for a full explanation. The formula is easy to modify to target other dates of the month. I've also included some formulas that work in older versions of Excel. VBA School Victor's VBA school course is still open until September 22. Victor gets a lot of good feedback on the course and I wanted to share two examples: George Lee, Aviation Industry: "I joined Launch Excel VBA School a few months ago. It's a well-designed learning experience. The course itself is well laid out and progressively takes a student from the basics up to useful fluency. Of course, you need to put the work in to make VBA work, but with the help of this course, it's much faster to get somewhere useful. In addition, I found that Victor replies very quickly to messages with requests for help and was very responsive to a request I had on how to fix my VBA code to activate a worksheet by year. It really helps to get quick feedback." Philip Shekoni, MBA, CFA, Senior financial analyst, Canada: "From someone who has taken different courses just to learn VBA (and most of the others costing multiples of what this one costs), this is one of the best courses on VBA that you'd find around. The building bricks are laid exceptionally well and in an order that makes for real understanding. The videos and projects are also really easy to follow. The instructor communicates well and is very responsive to questions. The course is very good for beginners and also has a lot to teach already-users. Finally, in case you didn't figure it out already, this costs much lower than what I would think the average cost for good VBA courses would be, and represents great value for money." If you want to learn VBA from the ground up, this course is a great option. You can find more detailed information here: [Click here for all the details]( The special price of $197 ends Friday, September 22. Excel formulas We maintain a list of over 500 working formulas [here](. If you need more structure, we also offer [video training](. Have a great weekend! Dave [View this email in a browser]( [Exceljet Logo]( Exceljet P.O. Box 4804 Salt Lake City, UT 84110 Copyright © 2023 Exceljet, All rights reserved. You received this email because you are subscribed to our newsletter. To unsubscribe, click the link below. [Unsubscribe](

Marketing emails from exceljet.net

View More
Sent On

08/11/2024

Sent On

27/09/2024

Sent On

13/09/2024

Sent On

06/09/2024

Sent On

30/08/2024

Sent On

23/08/2024

Email Content Statistics

Subscribe Now

Subject Line Length

Data shows that subject lines with 6 to 10 words generated 21 percent higher open rate.

Subscribe Now

Average in this category

Subscribe Now

Number of Words

The more words in the content, the more time the user will need to spend reading. Get straight to the point with catchy short phrases and interesting photos and graphics.

Subscribe Now

Average in this category

Subscribe Now

Number of Images

More images or large images might cause the email to load slower. Aim for a balance of words and images.

Subscribe Now

Average in this category

Subscribe Now

Time to Read

Longer reading time requires more attention and patience from users. Aim for short phrases and catchy keywords.

Subscribe Now

Average in this category

Subscribe Now

Predicted open rate

Subscribe Now

Spam Score

Spam score is determined by a large number of checks performed on the content of the email. For the best delivery results, it is advised to lower your spam score as much as possible.

Subscribe Now

Flesch reading score

Flesch reading score measures how complex a text is. The lower the score, the more difficult the text is to read. The Flesch readability score uses the average length of your sentences (measured by the number of words) and the average number of syllables per word in an equation to calculate the reading ease. Text with a very high Flesch reading ease score (about 100) is straightforward and easy to read, with short sentences and no words of more than two syllables. Usually, a reading ease score of 60-70 is considered acceptable/normal for web copy.

Subscribe Now

Technologies

What powers this email? Every email we receive is parsed to determine the sending ESP and any additional email technologies used.

Subscribe Now

Email Size (not include images)

Font Used

No. Font Name
Subscribe Now

Copyright © 2019–2025 SimilarMail.