Smart Calendar Suite | Leave Planner, Project Tracker & Countdown in one place
Most calendar apps do one thing well. Google Calendar handles events. LeaveDates handles leave. ClickUp handles projects. If you want all three, you are paying for multiple subscriptions, managing three separate tools, and still manually cross-checking who is on leave against your project deadlines.
The ExcelGuru Smart Calendar Suite was built to end that. One free, browser-based tool with a full interactive calendar, a leave planner, a project deadline tracker, live countdown timers, and export to both PDF and Excel — all in a single page, no account required, working perfectly for India, UAE, UK, and USA.
Whether you are an HR manager tracking five employees’ leave balances, a freelancer chasing client deadlines, or someone who just wants a clean yearly view with public holidays pre-loaded — this tool covers you.
💡 Why most free calendar tools fall short Google Calendar requires a Google account and only shows a monthly view. Notion needs templates and manual holiday entry. Free leave planners are Excel downloads that break when you open them on a phone. None of them combine leave + projects + countdowns in a single, instant, browser-based tool. |
What Is the Smart Calendar Suite?
The Smart Calendar Suite is a free, single-page web application that combines four productivity tools into one calendar interface. You open it in any browser — on desktop, tablet, or phone — and everything works immediately. No downloads, no accounts, no loading screens.
It is structured around four tabs:
- 📅 Calendar — the main view with yearly, monthly, and weekly modes
- 🏖️ Leave Planner — track up to 5 employees with leave balances, types, and overlap detection
- 📋 Project Tracker — add deadlines, monitor progress, and see live countdown badges
- ⏱️ Countdown Timers — ticking real-time counters for any event, deadline, or milestone
Three Calendar Views — Yearly, Monthly, and Weekly
Most tools offer only a monthly calendar. We built all three views because different planning tasks genuinely need different perspectives.
Yearly View — The Big Picture
The yearly view shows all 12 months side by side on a single screen. Public holidays appear in red on every month, leave periods are highlighted in green, and project deadlines show in amber. Click any month and you jump straight to its monthly detail.
This view is invaluable for HR managers planning team coverage across the year, or for freelancers trying to identify which months are already crowded with deadlines and which have capacity for new work.
Monthly View — Day-to-Day Management
The standard calendar grid, built for daily interaction. Each day cell shows up to three events colour-coded by type: holidays in red, leave in green, deadlines in amber, general events in blue, and countdown markers in purple. Click any day to select it, see a detail panel on the right, and quickly add events from the side panel without opening a modal.
Today’s date is always highlighted with a green circle. The selected day is visually anchored in the panel, showing all its events, any public holiday, and relevant leave entries.
Weekly View — Hour-by-Hour Planning
The weekly view shows seven days with time slots from All Day through 6 PM. This is the most useful view for shift planners and consultants who need to see work schedules at a granular level. Events, leave, and deadlines all appear on their respective day columns. The week automatically adjusts for UAE (Saturday–Friday) versus the standard Sunday–Saturday week in other countries.
🇦🇪 UAE-specific calendar logic The UAE working week runs Saturday through Thursday — Friday and Saturday are the weekend. Our calendar automatically adjusts the column order and weekend shading for UAE users. This is a detail that every other free tool misses, making this the only browser-based calendar that works correctly for Dubai and Abu Dhabi teams out of the box. |
Public Holidays — Pre-loaded for India, UAE, UK, and USA
Rather than asking you to manually enter holidays — a step that every other free tool requires — the Smart Calendar Suite pre-loads the correct public holidays for all four supported countries, across 2025 and 2026.
- 🇮🇳 India — Republic Day, Holi, Independence Day, Gandhi Jayanti, Diwali, Dussehra, Christmas, and more
- 🇦🇪 UAE — New Year, Isra Mi’raj, Eid Al Adha (all days), Arafat Day, Islamic New Year, National Day (Dec 2-3)
- 🇬🇧 UK — Good Friday, Easter Monday, all Bank Holidays, Summer Bank Holiday, Boxing Day
- 🇺🇸 USA — All 11 federal holidays including MLK Day, Memorial Day, Juneteenth, Thanksgiving, and Christmas
Switch country with one click at the top. The calendar redraws instantly — holidays update, weekends adjust, and the leave planner recalculates working days excluding the correct public holidays for your region.
Leave Planner — Track Up to 5 Employees
The leave planner is designed for small teams — up to five employees — who need something better than a shared Excel spreadsheet but do not need the complexity or cost of full HR software.
How it works
Click “+ Add Employee” and enter the person’s name, department, and annual leave allowance (the default is 25 days). The employee card appears showing a progress bar of days used versus remaining.
To mark leave, click “+ Mark Leave” or the “Add Leave” button on the employee card. Select the employee, start date, end date, and leave type. The tool automatically calculates the number of working days in the range — excluding weekends and the public holidays for the selected country — and deducts them from the employee’s allowance.
Six leave types supported
- Annual Leave — deducted from allowance
- Sick Leave — tracked separately, not deducted
- Casual Leave — tracked separately
- Work From Home (WFH) — visible on calendar, not deducted
- Maternity Leave — tracked separately
- Unpaid Leave — tracked separately
All leave periods appear on the main calendar in green, making it immediately visible when an employee is away. The leave planner also shows the last five leave entries per employee in reverse chronological order.
📄 Leave Report PDF Click “Leave PDF” in the export bar to generate a formatted leave summary report showing each employee’s total allowance, days used, days remaining, and a full table of every leave period with working-day counts. Ideal for end-of-year HR reviews or monthly team reports. |
Project Deadline Tracker
The project tracker lets you add work items with a start date, deadline, owner, and priority level (High, Medium, or Low). Each project card shows:
- A live countdown badge — e.g. “14 days left”, “Due today”, “3 days overdue”
- A color-coded progress slider — drag to update completion percentage from 0–100%
- Visual status badges — On track, Due soon, Overdue, Done
- Both dates displayed — start date and deadline in the same card
Project deadlines also appear on the monthly calendar as amber events, so you can see at a glance which weeks are heavy with deliverables and plan leave or other commitments accordingly.
The countdown badge color changes automatically: green when there is comfortable time remaining, amber when under 30 days, red when under 7 days, and a filled red badge when overdue.
Live Countdown Timers
The countdown tab shows ticking real-time counters for any event you add — days, hours, minutes, and seconds, updating every second in the browser.
Add a countdown for a product launch, a client presentation, a job interview, a holiday departure, or a birthday. Assign it one of six categories: Work Deadline, Birthday, Holiday Trip, Product Launch, Meeting, or Personal. Multiple countdowns run simultaneously on the same screen.
Past events flip to a red “passed” style — the counter continues running backward so you can see how many days ago something occurred.
Export Options — PDF and Excel, 4 Formats Each
The export bar at the bottom of the tool gives you six one-click options:
PDF exports (opens in new browser tab, then Save as PDF)
- Monthly PDF — full A4 calendar grid with all events, colour-coded, print-ready
- Yearly PDF — all 12 mini-months + full public holidays list for the year
- Leave Report PDF — per-employee leave summary with working-day calculations
- Project Report PDF — sortable deadline table with status badges and progress
Excel export (instant download)
The Excel export generates a .xlsx file with four sheets:
- Calendar Events — all custom events with date, title, type, and notes
- Leave Summary — all employees with allowance, used, remaining, and every leave entry
- Projects — all project cards with owner, priority, dates, progress, and status
- Countdowns — all countdown events with target date, category, and days remaining
The Print button triggers a browser print dialog styled with clean print CSS — the header, tabs, sidebar, and export bar all disappear, leaving a clean calendar grid suitable for wall-mounting or filing.
Who Is This Tool For?
Who | How they use it | Best feature for them |
Employee / salaried worker | Check remaining leave, plan holidays around public holidays | Leave balance bar + country holiday calendar |
HR Manager (small team) | Track 5 employees’ leave, spot overlaps, export PDF report | Leave planner + PDF leave report |
Freelancer / consultant | Track client deadlines, set countdown for deliverables | Project tracker + countdown timers |
Project manager | Monitor multiple deadlines, milestone progress, team schedule | Project cards + Gantt bars + Excel export |
Student | Assignment deadlines, exam countdowns, term planner | Countdown timers + monthly view |
Family / personal | Holiday planning, birthday countdowns, school calendar | Yearly view + event colour codes |
How ExcelGuru Compares to Other Free Calendar Tools
Feature | ExcelGuru | Google Calendar | Notion | LeaveDates | ClickUp |
Yearly/Monthly/Weekly views | All 3 — free | Monthly only | Monthly only | Monthly only | Paid |
Public holidays (4 countries) | Built-in — IN/AE/GB/US | Manual add | Manual add | Limited | Manual |
Leave planner | Free — 5 employees | No | Template only | Core feature (paid) | Paid |
Project deadline tracker | Free + countdown | No | Template | No | Paid |
Live countdown timers | Yes — ticking | No | No | No | No |
UAE Fri/Sat weekend | Auto-detected | No | No | No | No |
PDF export (4 formats) | Monthly/Yearly/Leave/Projects | No | No | Paid | Paid |
Excel export | 4 sheets — free | No | CSV only | Paid | Paid |
Print-ready calendar | Yes | Limited | No | No | No |
No sign-up required | Yes | Google account | Account | Account | Account |
Works offline (browser) | Yes | No | No | No | No |
How to Use the Smart Calendar Suite — Step by Step
- Open the tool in any browser — no download, no account, works immediately.
- Select your country from the top bar (India, UAE, UK, or USA). Public holidays load instantly.
- Choose your calendar view — Yearly for the big picture, Monthly for day-to-day, Weekly for detailed scheduling.
- Navigate months using the left/right arrows, or click Today to return to the current date.
- Click any day on the monthly calendar to select it. The side panel shows that day’s events and a quick-add form.
- To add an event, type the title in the Quick Add panel and choose a type (Event, Leave, Deadline, or Shift). Click Add.
- For the Leave Planner tab: add employees with their annual allowance, then mark leave periods by selecting dates and leave type.
- For the Projects tab: add project name, owner, priority, start date, and deadline. Use the progress slider to update completion.
- For the Countdown tab: add any event with a name, date, and category. The timer starts ticking immediately.
- Export at any time — click Excel for a full download, or choose a PDF format for a print-ready report.
- Print the current monthly calendar using the Print button for a clean, header-free paper version.
Pro Tip Combine views for maximum planning power Start with the Yearly view to see your whole year — spot months heavy with holidays and deadlines. Then switch to Monthly for any specific month to add events and mark leave. Use the Weekly view during the working week to stay on top of daily commitments. Each view updates instantly from the same underlying data. |
Frequently Asked Questions
Is the Smart Calendar Suite completely free?
Yes, entirely free. No account, no subscription, no premium tier. Every feature including all PDF and Excel exports is available to everyone.
Does my data get saved anywhere?
No. All data lives in your browser session memory. Nothing is sent to any server. If you close and reopen the tab, the data resets — so use the Excel export to save a copy before closing.
Which countries’ public holidays are included?
India (national holidays for 2025-2026), UAE (public holidays including all Eid dates for 2025-2026), UK (England and Wales bank holidays), and USA (federal holidays). Switch countries with one click at the top.
Does the UAE calendar handle Friday-Saturday weekends correctly?
Yes. When UAE is selected, the calendar automatically rearranges the column order to start with Saturday, highlights Friday and Saturday as weekends, and adjusts leave calculations to exclude those days instead of Saturday and Sunday.
How many employees can I add to the Leave Planner?
Up to 5 employees. Each employee can have unlimited leave entries across all six leave types.
Can I use this on mobile?
Yes. The tool is fully responsive — it works on phones, tablets, and desktops. The sidebar collapses on smaller screens and the calendar grid adjusts to available width.
How do I export a leave report?
Click the “Leave PDF” button in the export bar at the bottom of the page. A formatted report opens in a new browser tab. Use your browser’s Print function and select “Save as PDF” to download it.
Can I add custom events that are not leave or projects?
Yes. Use the Quick Add panel on the right sidebar (when a day is selected) to add a general Event, a Shift, a Leave entry, or a Deadline directly to any date. Full details can be added via the modal by clicking any of the “+ Add” buttons on the respective tabs.