Imagine you are head of human resources at Casual Contracting Co. Every month you hire a lot of temporary staff who spend 1-4 months with CCC before leaving. Sometimes you hire the same people again. Of late, you have noticed a strange process gap. You are paying same person two (or more) salaries.
This is because you are hiring a person for new temp role even before their current one ended. See below picture.
So how to avoid making such hiring boo-boos.
Simple, using Excel of course.
There are a few ways to handle this problem.
- Using formulas to check if a person is hired twice in the same period
- Using conditional formatting to highlight such hires
- Using data validation to prevent such data entry
I made a video covering all these methods in detail. Check it out below or on Chandoo.org YouTube channel.
Download hiring boo-boos workbook
Click here to download the workbook showcased in the video. Play with various dates & names to test formulas, CF and data validation.
Avoid Excel Boo-boos, Show it who-da-boss
Learning few simple Excel best practices and techniques can save you a lot of time & money. So why wait, check out below links and become awesome in Excel.
- Advanced Excel skills & resources – learn the right way
- What is Conditional Formatting and how to use it? [Video]
- 5 tips to become conditional formatting rock star
- Introduction to SUMIFS
- MAX IF formula
While you are at this, subscribe to Chandoo.org YouTube channel. I have been uploading videos once a month. While this is not exactly a staggering pace, you are sure to be a rockstar at work if you just watch all the previous vids and stay tuned for more. Check it out.
11 Responses to “FREE Calendar & Planner Excel Template for 2025”
Hi,
I downloaded this 2025 Calendar template. I checked the custom tab. Is it possible to change the weekend Fri & Sat.
Thanks
It is. Just use the option for fri & sat weekend (should be 7).
Activities of some dates are not getting displayed on "Any month" and "printable calendar" sheets.
e.g. Activity of 24 Apr 25.
Can you check again? The date in "planner" sheet should be a proper date. When I tested with 24-apr-2025, it works.
Love this calendar... I have highlight planner dates enabled but all dates are blue, is it possible to customize the color based on the type assigned to each date?
What would be the right way to add more Holidays in the Customizations?
Inserting rows in the Holiday List causes the blank cells in the calendar to turn Blue.
This is amazing!!! The best I've seen so far!! Is it possible to update it to consider a column for the final date? That way, if an event lasts more than one day, it repeats in the calendar
How do we change/insert the customization "Icon Options" ?
You can adjust these from the settings tab.
Is there anyway this can turn into an academic calendar (ie. start month is July and runs all the way through June of next year)?
Is there a way to make it something that is more than a day without having to add it to every day of that week.