A simple work availability calendar gives colleagues, clients, and managers a reliable view of when you can work. You can create one with a spreadsheet, Google Calendar, or another calendar app, depending on whether you need a shared schedule or a private planning tool.
Decide what your calendar needs to show
Before opening an app, decide what “availability” means for your situation. A useful calendar is not necessarily complicated. It needs to answer three questions quickly:
- Which days are you available?
- During what hours can someone schedule you?
- Are there exceptions, such as appointments, holidays, or changing shifts?
For a regular Monday-to-Friday schedule, a weekly calendar may be enough. For rotating shifts, freelance work, part-time hours, or irregular commitments, you may need a monthly view or a rolling schedule covering several weeks.
Also decide whether the calendar is for your own planning or for other people to use. A personal calendar can include detailed notes. A shared availability calendar should reveal only the information people need. For example, “Unavailable” is usually more appropriate than a private medical, family, or financial explanation.
Write down your normal working pattern before building the calendar. Include your time zone, standard working days, preferred contact method, and any booking rules, such as requiring 24 hours’ notice.
Choose Excel, Google Calendar, or another tool
The best tool depends on how often your availability changes and how many people need access.
| Tool | Best for | Main limitation |
|---|---|---|
| Excel or Google Sheets | A simple weekly or monthly grid | Changes may need to be updated manually |
| Google Calendar | Shared bookings and automatic time-zone handling | Requires careful permission settings |
| Outlook Calendar | Organizations already using Microsoft 365 | Some sharing features depend on account settings |
| Paper or PDF calendar | Printing or posting a fixed schedule | Not suitable for frequent changes |
Use a spreadsheet when you want a clear overview, need to print the schedule, or want to create a reusable template. Use a calendar app when people need to book meetings, check live availability, or receive updates automatically.
You can also combine the two. For example, maintain a detailed personal calendar in Google Calendar and publish a simplified weekly availability table in a spreadsheet or document.
Create a simple availability calendar in Excel or Google Sheets
A spreadsheet is one of the fastest ways to create a straightforward availability calendar.
1. Create the basic layout
Open a new workbook or spreadsheet. Put the days of the week across the top row and time periods down the first column. For example:
| Time | Monday | Tuesday | Wednesday | Thursday | Friday |
|---|---|---|---|---|---|
| 8:00–9:00 | Available | Available | Unavailable | Available | Available |
| 9:00–10:00 | Available | Available | Unavailable | Available | Available |
| 10:00–11:00 | Available | Break | Unavailable | Available | Available |
| 11:00–12:00 | Available | Break | Available | Available | Available |
| 12:00–1:00 | Lunch | Lunch | Lunch | Lunch | Lunch |
| 1:00–2:00 | Available | Available | Available | Unavailable | Available |
| 2:00–3:00 | Available | Available | Available | Unavailable | Available |
| 3:00–4:00 | Available | Available | Available | Unavailable | Available |
You do not need to list every hour if your work is flexible. You could instead use blocks such as “Morning,” “Afternoon,” and “Evening.” Smaller time intervals are more useful when people need to schedule appointments.
2. Use consistent labels
Choose a small set of labels and use them throughout the calendar. For example:
- Available: You can normally accept work or meetings.
- Limited: You may be available, but advance notice or confirmation is needed.
- Unavailable: Do not schedule work during this period.
- Break: You are not working, even if you are physically reachable.
- Tentative: The time may change and should not be treated as confirmed.
Avoid using several phrases that mean the same thing. “Free,” “Open,” “Available,” and “Can work” may confuse people if they are used inconsistently.
3. Add color carefully
Color can make the schedule easier to scan, but it should not be the only way information is communicated. Use text labels as well as colors because some people have color-vision deficiencies and some printed copies may appear in grayscale.
A practical scheme is:
- Green for Available
- Yellow for Limited or Tentative
- Gray for Break
- Red or dark gray for Unavailable
Keep the colors light enough that the text remains readable. In Excel, you can apply conditional formatting based on the cell text. In Google Sheets, select the calendar range, open Conditional formatting, and create rules such as “Text is exactly Available.”
4. Add important details above the grid
Place a short information block above the schedule. It might include:
- Name or team
- Effective dates
- Time zone
- Normal working location, if relevant
- Last updated date
- Booking instructions
- Contact method for urgent changes
For example:
Availability for Jordan Lee — September 23–27, 2026. Times shown in Central European Time. Please request meetings at least one business day in advance. Last updated September 22.
An effective date is particularly important. A weekly pattern without a date range may be mistaken for a permanent commitment.
5. Protect the structure if others will edit it
If people only need to view the calendar, share a view-only link or export a PDF. If others need to add bookings, protect the labels, formulas, and headings so they cannot accidentally change the template.
In Google Sheets, use Protect sheets and ranges. In Excel, use Protect Sheet after deciding which cells should remain editable. Keep a private backup copy before sharing an editable version.
Build the calendar in Google Calendar
Google Calendar is more suitable when availability changes regularly or people need to see your current schedule.
1. Create a separate calendar
Instead of mixing every availability entry with personal appointments, create a separate calendar named something like “Work Availability.” A separate calendar lets you control its visibility independently.
On a computer, open Google Calendar, select the plus sign beside Other calendars, and choose Create new calendar. Give it a clear name and select a time zone. Add a description explaining whether the calendar shows working hours, open booking slots, or general availability.
2. Add recurring working hours
Create a recurring event for each regular availability block. For example, you might create “Available for work” from 9:00 a.m. to noon every weekday, then another event from 1:00 p.m. to 4:00 p.m. This approach makes the lunch break explicit rather than leaving it ambiguous.
When creating the event:
- Enter a descriptive title, such as “Available for meetings.”
- Set the correct start and end times.
- Choose the correct time zone if you work with people elsewhere.
- Set the event to repeat on the appropriate days.
- Select the availability calendar rather than your personal calendar.
- Save and review several future dates.
Do not create one all-day event called “Available.” An all-day event does not communicate which hours can actually be booked.
3. Add exceptions
Recurring events describe the normal pattern, but exceptions are essential. Add one-time events for holidays, travel, appointments, training, illness, or temporary schedule changes.
Use simple titles such as “Unavailable” or “Limited availability.” If the calendar is shared publicly or with clients, avoid exposing sensitive details. Set the event to the correct calendar and confirm that it overlaps the recurring availability block as intended.
If you cancel or edit one occurrence of a recurring event, check whether you changed only that date or the entire series. Calendar applications usually offer options such as “This event,” “This and following events,” or “All events.” Choosing the wrong option can silently change future availability.
4. Configure sharing permissions
Sharing settings determine how much others can see. Depending on the platform, you may be able to allow people to:
- See only free or busy status
- See event titles and locations
- Make changes to the calendar
- Manage sharing permissions
Use the least permissive setting that still solves the scheduling problem. If someone only needs to know whether you are free, free/busy visibility is usually sufficient. Review the link and sharing list regularly, especially when a project or contract ends.
Make the calendar easy to use
A technically accurate calendar can still cause problems if people do not know how to interpret it. Add a small legend and state what each label means.
For example:
- Available means a request can normally be accepted.
- Limited means confirmation is required before booking.
- Unavailable means do not schedule during that period.
- Tentative means the time may change.
State whether travel time, preparation time, and breaks are already included. If you need a 15-minute buffer between meetings, block that time rather than expecting others to infer it.
Use one time format throughout the calendar. Either use a 12-hour format with AM and PM or a 24-hour format. Avoid writing “9–5” if the schedule crosses a time zone or if the end time could be misunderstood.
For remote work, include the time zone in the title, description, or header. “9:00–17:00 CET” is clearer than “9 to 5.” Remember that Central European Time and Central European Summer Time differ seasonally; calendar applications generally handle daylight-saving changes when the correct regional time zone is selected.
Create a reusable weekly template
If your schedule follows a predictable pattern, make a template instead of rebuilding it each week. Include the following elements:
- A title containing the person, team, or service name.
- A date range or week-start field.
- Day and time headings.
- Standard availability labels.
- A legend.
- Time-zone information.
- A last-updated field.
- A notes area for exceptions.
In a spreadsheet, duplicate the clean template before adding each new week. In a calendar app, use recurring events and add exceptions. Keep the original template separate from the version shared with other people so it is not overwritten accidentally.
If you use formulas to calculate hours, test them when a shift crosses midnight or when a day is marked unavailable. A basic total-hours formula may not handle overnight work correctly without additional date information.
Troubleshoot common problems
People schedule you during a blocked period
Check whether the person is viewing the correct calendar and whether the event is marked as busy. In Google Calendar or Outlook, an event may exist but still appear available if its status is set incorrectly. Also check whether the recurring availability event takes priority over an unavailable event in the shared view.
The times look different to other people
Confirm the time zone on both calendars. Avoid manually converting times in a spreadsheet unless everyone uses the same time zone. A calendar application with a named regional time zone is safer than a fixed offset because daylight-saving changes may affect the displayed time.
The schedule has become outdated
Add a visible last-updated date and an expiration date. Set a recurring reminder to review the calendar weekly or monthly. If the schedule changes frequently, a live shared calendar is generally more reliable than repeatedly emailing spreadsheet attachments.
The calendar is difficult to read on a phone
Reduce unnecessary columns, use short labels, and avoid tiny text. For a mobile-friendly version, use one row per availability block rather than a dense grid. A calendar application may be easier to read than a wide spreadsheet on a small screen.
Recurring events create unexpected availability
Open the series and inspect the repeat rule, end date, and exceptions. A recurring event with no end date can continue indefinitely. When your schedule changes permanently, end the old series and create a new one rather than adding many confusing edits.
Understand the limitations
An availability calendar shows when you may be able to work; it does not guarantee capacity, approval, or response time. A person may be marked available but still need to confirm the task, review its scope, or account for preparation and travel.
A shared calendar can also expose more information than intended. Check whether event titles, locations, guest lists, or notes contain private data. Do not publish a public link unless you understand exactly what viewers can see.
Finally, keep a communication process alongside the calendar. Explain how people should request time, what notice is required, and where urgent changes should be sent. The calendar provides the schedule, while the booking rules explain how to use it.