Home » Expert » How to make automatic calendar in Excel

How to make automatic calendar in Excel

Reading time: 5 minutes
Last Updated on 21/05/2023 by Frédéric LE GUEN

How to create an automatic calendar with Excel where the colors of weekends and holidays change automatically for each month. This article will detail you step-by-step how to build it.

If you want a calendar that saves data from one month to the next, refer to this article.

Demo Calendar Excel

Step 1: Add employee names

In column A, write the names of your employees.

Step 2: Add a drop-down menu as an object.

It is very easy to create drop-down menus in Excel, but with this technique, it is not possible to attach a macro to them.

In this workbook, the macro will be used to hide the days according to the number of days in the month. So we must add a drop-down menu as an object.

  1. Go to the menu File>Options
  2. Then Customize the Ribbon
  3. Check the Developer option in the right pane
Add developer menu in the ribbon

Step 3: Insert an object Drop-down menu

  • Set yourself to A1 to create the drop-down menu for the months.
  • Now on the ribbon, select Developer > Insert > combo box
Menu to insert a dropdown button for macros

With the mouse, click and stretch to make your "Drop-down Menu" object appear in your spreadsheet

Step 4: Create the monthly list

Now we will create the list of months somewhere in our workbook (in a fairly distant column).

Automatic_Calendar_4

Don't waste time writing months one after the other, the copy handle does it for you.

Step 5: Link the drop-down menu to a cell

Next, you must link the Drop-down menu object to a cell in the workbook to retrieve the selected value.

  1. Select your drop-down object
  2. Right-click
  3. Select Control Format
Option for the dropdown button

The following dialog box opens

  1. Select the Control tab (the last one)
  2. Select the range of month (in this example AH1:AH12
  3. In the Cell link, select A1 (explanation, just under)

What is the cell link?

  • If you select May, the 5th element in the list, the value in A1 will be 5
  • And if you select September the value in A1 will be 9
  • ...

Step 6: Drop-down menu for years

Reproduce the same manipulations to have a drop-down menu for the years

  • Create a column for years
  • Insert a new drop-down menu
  • Link the year's column with the new drop-down menu
  • Associate the drop-down menu with cell A2

Step 7: Create the date according to the selected month and year

We will now create a formula that will retrieve the cells linked A1 (for months) and A2 (for years) to return on the first day of the month.

To do this, we will use the DATE function with the contents of the linked cells.

  • For A1, the cell of the month, it's very simple; Just take the data as it is in the formula
  • For A2, the drop-down menu will return the values 1, 2, 3, ... corresponding to the selected value. To make this value coincide with a year, a fixed value must be added. For example, add 2014 to the linked cell to create the year 2015.

The formula is therefore

=DATE(A2+2016,A1,1)

Step 8: Create the other days of the month

To calculate the other days, the formula is easier. Just add 1 to the previous cell and copy this formula on the data range C6 to AF6

=B6+1

Step 9: Change the date format

In this step, we will change the format of the dates to make the day appear in letters and numbers

  • Select all your dates from line 6 (from B6 to AF6)
  • Open the Number Format dialog box (keyboard shortcut Ctrl + 1 or Home>Number Format>Other Numeric Formats ...
  • Select the Custom category and enter the ddd dd format in the Type box
Change the format of the dates

Step 10: Change the orientation of the text

Now we will change the orientation of the dates to display them vertically.

  • Select B6:AF6
  • Activate the menu Home
  • Orientation
  • Rotate Text Up
Menu to rotate the wording

And to finish the job, adjust the size of the columns from B to AF

  1. Select columns B:AF
  2. Right-click in the column header
  3. Choose Column Width
  4. Set the column width to 2.5

The timetable is progressing very well. By changing the values in the drop-down menus, you see the days of the selected month.

Step 11: Format your calendar

Add borders and color to your calendar.

Step 12: Add a dynamic title

We will now create a title that will adapt to the selected month and year.

First and last date of the month

The formula for the first day is:

=DATE(A2+2016,A1,1)

The formula for the date of the last day of the month is:

=DATE(A2+2016,A1+1,1)-1

Formula for dynamic title

All we have to do is insert these 2 functions into a TEXT function

="Period from the "&TEXT(DATE(A2+2016,A1,1),"dd mmmm yyyy") &" to the "&TEXT(DATE(A2+2016,A1+1,1)-1,"dd mmmm yyyy")

And the result becomes:

Step 13: Change the color of weekends and holidays

To change the colors of the holidays, we will use conditional formatting and especially methods with custom formulas. We will create 2 rules

  • one for weekends
  • another for public holidays.

Rule for weekends

  1. Select your B6:AF13 data range
  2. Create a new conditonal formatting rule (Home>Conditional Formatting>New Rule)
  3. Select the Use a formula option to determine which cells the format will be applied to
  4. Write the formula =EMDAYS(B$6,2)>5
  5. Change the fill color (here from orange)

Very, very, VERY IMPORTANT ❗❗❗ There is only one $ in the formula after the column B

Rule for holidays

Here we need to integrate into our workbook the list of public holidays in your country. By clicking on this link, you will find the formulas to calculate the US public holidays.

USA Public holiday 2019

The formula for this rule is different from the previous calculation. Here we will use the COUNTIF function

  1. Select all your data (cells B6:AF13)
  2. Create a conditional formatting rule (Home>Conditionnal Formating>New rules)
  3. Select Use a formula to determine which cells to format
  4. Write the formula =COUNTIF(Holidays!$B$2:$B$4,B$6)>0
  5. Change the background color (red)

Check your rules

Open the conditional rules manager (Home>Conditional Formatting>Manage Rules), you can view the 2 rules created in your spreadsheet.

Don't forget to select This spreadsheet from the first drop-down menu to view all rules.

Conditional formatting rules

Step 14: Hide the last columns by Macro

Since not all months have the same number of days, we will hide the columns not belonging to the selected month.

All the explanations about the code are given in this article

The program will read the AD, AE and AF columns to verify that the value of the month in these cells is equal to the value contained in A1 (value of the selected month). If not, the column is hidden.

  1. Press Alt + F11 to open the Visual Basic Editor
  2. From the Insert menu, choose Module
  3. Copy Paste the following code in your module

Sub Hide_Day()
Dim Num_Col As Long
'This instruction clears the content of the cells in your calendar
Range("B7:AF13").ClearContents
For Num_Col = 30 To 32
' Test if the month of the cells (row 6) is the same as the month selected (cell A1 or cells(1,1))
If Month(Cells(6, Num_Col)) >= Cells(1, 1) Then
Columns(Num_Col).Hidden = True
Else
Columns(Num_Col).Hidden = False
End If
Next

Step 15: Link the drop-down menus to the macro

To finish the job, we still have to link the 2 drop-down menus with the macro. This way, with each new selection, the macro will be launched.

  1. Select the Combo Box
  2. Right-click on it.
  3. Choose Assign Macro
  4. Select the name of the macro (Hide_Day)
  5. Click OK
  6. Do the same operation again for the second drop-down menu

Now, whenever you select a month or year from the drop-down menus, your calendar will update and the columns will hide (or show) automatically.

Automatic calendar finished

88 Comments

  1. Jamal
    17/02/2023 @ 17:20

    Hi the only problem I have is right at the end, for e.g. if I fill the cell for one of the days in February, then change the month to March I can't see no content which I want. However after I click on March and want to go back to February all my content disappears, which I don't want. So basically if I populate info for any month and the click off and come back to that month, everything that I populated it with disappears. Is there anyway to over come this.

    Reply

  2. Allen
    17/02/2023 @ 15:13

    My days don’t change? What did I do wrong?

    Reply

  3. konstie
    24/11/2022 @ 18:38

    so i have reached the point to highlight the public holidays.
    now i want a different column to count how many workdays each employee has. i used the code =COUNTIF(D10:AH10; "O") and i mark with an "O" each work day of each person. but what if i want to count working weekends and working holidays separately? so that when i fill in the calendar i can see how many sundays and saturdays each employee has to work?

    Reply

  4. Celine Moutic
    17/11/2022 @ 19:48

    Hi Frédéric and thanks for this very helpful tutorial!!
    I just have one tiny issue which I hope you can help out with >> When I want to add little "x"s to the month of August for a specific employee, for instance, I see that the "x"s also appear in all the other months as well. How can we restrict that the "x'"s only show in the month of August?

    Thank you so much in advance!!

    Reply

    • Frédéric LE GUEN
      20/11/2022 @ 10:31

      I don't understand your question because the calendar used a single worksheet. So how can you have "x" for other months?

      Reply

      • Vicky
        17/01/2023 @ 10:42

        Τhe "x" are probably the text that an employee works on 1st of august for example. How can we make that information follow the spesific date and only show up on the 1st of august 1st employee cell ?
        now whatever you type on one month stays there for all months . we need to save the month and go to the next one starting blank, is that possible?

  5. Aldrin C
    07/08/2022 @ 06:11

    Thank you for this. But how can i change the Weekend. here is Saudi, our weekend is Friday and Saturday.

    Reply

    • Frédéric LE GUEN
      18/08/2022 @ 14:45

      I see, Change the WEEKDAY argument to 5 or 6 (I don't remember exactly) and it will work

      Reply

  6. Hiren
    07/07/2022 @ 11:10

    Thanks for the tutorial. I managed to finish all except the last 2 steps... could not get the proper understanding on how. to....

    Reply

  7. kaila
    12/05/2022 @ 21:51

    I will say that the macro does not work if you aren't sure what you're building. Especially since you can't see the full workbook they are using. I've just skipped the macro entirely and just made the text white.

    Reply

  8. Lisa Nieth
    10/02/2022 @ 18:05

    Thank you for the tutorial. I was able to create the calendar, but would like each cell to have a drop down box with a list of options for employees to choose from. If I do Data Validation and create the list for the cells in the calendar, it works. However, if I enter a choice from the list for Feb 10, it keeps that selection for the 10th of every month. How can I make my list in the calendar cells not repeat into other months? I'm not an excel expert and don't know how to figure this out without assistance.

    Reply

    • Asdfy
      14/03/2022 @ 01:54

      Yes, because the calendar is in the same place ... every time you change the month from the drop-down menu, a macro is activated which deletes the data and changes the month according to your choice, but in fact it happens in the same place.
      You can try like that... Make a calendar for the whole year, after just change the code like that

      Sub Hide_Day()
      Dim Num_Col As Long

      Num_Col = 365 'The amount of columns needed for all months of the year

      For Num_Col = 2 To 365 ' I assume the Calendar will start from B. You will need a Column for the Names of the Workers

      If Month(Cells(6, Num_Col)) = Cells(1, 1)
      Columns(Num_Col).Hidden = False
      Else
      Columns(Num_Col).Hidden = True
      End If
      Next
      End Sub

      Reply

  9. shashi
    07/11/2021 @ 06:41

    macro is not working. Pls help

    Reply

  10. Hisham
    15/09/2021 @ 15:34

    Many Thanks

    Reply

  11. Lilian
    27/08/2021 @ 15:20

    Thanks for this, very clear and i succeeded in creating the calender. However how do I let the data keyed on the field do not disappear once the month change? Do you already have the data to share?

    Reply

    • Frédéric LE GUEN
      01/09/2021 @ 14:12

      In fact, your question is more "how to save the value for each month". And the answer is "not possible with Excel". Have a look at Microsoft Planner in your Office 365 account.

      Reply

  12. Malena
    06/07/2021 @ 12:13

    Hi
    let's say the calendar starts at 28th and ends with 27th. Ex. from 28th feb 2021 to 27th marts 2021 but the row continues to 30th, and i want to hide 28th, 29th and 30th.
    is it the same code or do i have to change a little bit?

    Reply

  13. A
    07/11/2020 @ 13:59

    Great guide. I know this is an older post but having trouble with countif and dates of holidays. I am trying to make a calendar for scheduling during critical days and to quickly see if employee time off during holidays conflict with each other.

    Reply

  14. Haris Awan
    03/11/2020 @ 22:53

    Hi, I'm having difficulty in the macro coding. it showing error *COMPILE ERROR* SYNTAX ERROR
    Can anyone assist me with it ?

    Reply

  15. Exar
    26/11/2019 @ 01:46

    Hi,
    Thank you for this tutorial.
    Would you mind sharing how you go about to saving the data from month to month without it being cleared?

    This template becomes extremely useful with the ability to retain data.
    Thank you again.

    Reply

    • Frédéric LE GUEN
      26/11/2019 @ 15:02

      Hi, Thanks to appreciate my article but I can't reply to your message just like that. It's a full development here because if you want to display the previous result, that means that each cells have formulas to collect the previous result (this formula is not easy and depend of the contexte of each worksheet). And of course, if you update one value in the calendar, you will delete the formula. I hope you understand the complexity of a such project. I can but it's a development (2 or 3 days for me)

      Reply

      • Hussain
        31/12/2019 @ 01:02

        Dear Mr. Frédéric LE GUEN

        Thanks for this beautiful explanation
        I followed your step-by-step explanation, and the result was beautiful, but when I return to a month in which the days are 30 days or 31 days, the days remain hidden.
        Please, if possible, attach the calendar file. I will be appreciated you.

      • Frédéric LE GUEN
        03/01/2020 @ 06:37

        There is a problem with your macro for sure. Probably the row for your days is not the one mention in the code.
        Have a look at this link to understand the code and also to customize it.
        No, I don't share the file. It's not the way to learn how to use Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

How to make automatic calendar in Excel

Reading time: 5 minutes
Last Updated on 21/05/2023 by Frédéric LE GUEN

How to create an automatic calendar with Excel where the colors of weekends and holidays change automatically for each month. This article will detail you step-by-step how to build it.

If you want a calendar that saves data from one month to the next, refer to this article.

Demo Calendar Excel

Step 1: Add employee names

In column A, write the names of your employees.

Step 2: Add a drop-down menu as an object.

It is very easy to create drop-down menus in Excel, but with this technique, it is not possible to attach a macro to them.

In this workbook, the macro will be used to hide the days according to the number of days in the month. So we must add a drop-down menu as an object.

  1. Go to the menu File>Options
  2. Then Customize the Ribbon
  3. Check the Developer option in the right pane
Add developer menu in the ribbon

Step 3: Insert an object Drop-down menu

  • Set yourself to A1 to create the drop-down menu for the months.
  • Now on the ribbon, select Developer > Insert > combo box
Menu to insert a dropdown button for macros

With the mouse, click and stretch to make your "Drop-down Menu" object appear in your spreadsheet

Step 4: Create the monthly list

Now we will create the list of months somewhere in our workbook (in a fairly distant column).

Automatic_Calendar_4

Don't waste time writing months one after the other, the copy handle does it for you.

Step 5: Link the drop-down menu to a cell

Next, you must link the Drop-down menu object to a cell in the workbook to retrieve the selected value.

  1. Select your drop-down object
  2. Right-click
  3. Select Control Format
Option for the dropdown button

The following dialog box opens

  1. Select the Control tab (the last one)
  2. Select the range of month (in this example AH1:AH12
  3. In the Cell link, select A1 (explanation, just under)

What is the cell link?

  • If you select May, the 5th element in the list, the value in A1 will be 5
  • And if you select September the value in A1 will be 9
  • ...

Step 6: Drop-down menu for years

Reproduce the same manipulations to have a drop-down menu for the years

  • Create a column for years
  • Insert a new drop-down menu
  • Link the year's column with the new drop-down menu
  • Associate the drop-down menu with cell A2

Step 7: Create the date according to the selected month and year

We will now create a formula that will retrieve the cells linked A1 (for months) and A2 (for years) to return on the first day of the month.

To do this, we will use the DATE function with the contents of the linked cells.

  • For A1, the cell of the month, it's very simple; Just take the data as it is in the formula
  • For A2, the drop-down menu will return the values 1, 2, 3, ... corresponding to the selected value. To make this value coincide with a year, a fixed value must be added. For example, add 2014 to the linked cell to create the year 2015.

The formula is therefore

=DATE(A2+2016,A1,1)

Step 8: Create the other days of the month

To calculate the other days, the formula is easier. Just add 1 to the previous cell and copy this formula on the data range C6 to AF6

=B6+1

Step 9: Change the date format

In this step, we will change the format of the dates to make the day appear in letters and numbers

  • Select all your dates from line 6 (from B6 to AF6)
  • Open the Number Format dialog box (keyboard shortcut Ctrl + 1 or Home>Number Format>Other Numeric Formats ...
  • Select the Custom category and enter the ddd dd format in the Type box
Change the format of the dates

Step 10: Change the orientation of the text

Now we will change the orientation of the dates to display them vertically.

  • Select B6:AF6
  • Activate the menu Home
  • Orientation
  • Rotate Text Up
Menu to rotate the wording

And to finish the job, adjust the size of the columns from B to AF

  1. Select columns B:AF
  2. Right-click in the column header
  3. Choose Column Width
  4. Set the column width to 2.5

The timetable is progressing very well. By changing the values in the drop-down menus, you see the days of the selected month.

Step 11: Format your calendar

Add borders and color to your calendar.

Step 12: Add a dynamic title

We will now create a title that will adapt to the selected month and year.

First and last date of the month

The formula for the first day is:

=DATE(A2+2016,A1,1)

The formula for the date of the last day of the month is:

=DATE(A2+2016,A1+1,1)-1

Formula for dynamic title

All we have to do is insert these 2 functions into a TEXT function

="Period from the "&TEXT(DATE(A2+2016,A1,1),"dd mmmm yyyy") &" to the "&TEXT(DATE(A2+2016,A1+1,1)-1,"dd mmmm yyyy")

And the result becomes:

Step 13: Change the color of weekends and holidays

To change the colors of the holidays, we will use conditional formatting and especially methods with custom formulas. We will create 2 rules

  • one for weekends
  • another for public holidays.

Rule for weekends

  1. Select your B6:AF13 data range
  2. Create a new conditonal formatting rule (Home>Conditional Formatting>New Rule)
  3. Select the Use a formula option to determine which cells the format will be applied to
  4. Write the formula =EMDAYS(B$6,2)>5
  5. Change the fill color (here from orange)

Very, very, VERY IMPORTANT ❗❗❗ There is only one $ in the formula after the column B

Rule for holidays

Here we need to integrate into our workbook the list of public holidays in your country. By clicking on this link, you will find the formulas to calculate the US public holidays.

USA Public holiday 2019

The formula for this rule is different from the previous calculation. Here we will use the COUNTIF function

  1. Select all your data (cells B6:AF13)
  2. Create a conditional formatting rule (Home>Conditionnal Formating>New rules)
  3. Select Use a formula to determine which cells to format
  4. Write the formula =COUNTIF(Holidays!$B$2:$B$4,B$6)>0
  5. Change the background color (red)

Check your rules

Open the conditional rules manager (Home>Conditional Formatting>Manage Rules), you can view the 2 rules created in your spreadsheet.

Don't forget to select This spreadsheet from the first drop-down menu to view all rules.

Conditional formatting rules

Step 14: Hide the last columns by Macro

Since not all months have the same number of days, we will hide the columns not belonging to the selected month.

All the explanations about the code are given in this article

The program will read the AD, AE and AF columns to verify that the value of the month in these cells is equal to the value contained in A1 (value of the selected month). If not, the column is hidden.

  1. Press Alt + F11 to open the Visual Basic Editor
  2. From the Insert menu, choose Module
  3. Copy Paste the following code in your module

Sub Hide_Day()
Dim Num_Col As Long
'This instruction clears the content of the cells in your calendar
Range("B7:AF13").ClearContents
For Num_Col = 30 To 32
' Test if the month of the cells (row 6) is the same as the month selected (cell A1 or cells(1,1))
If Month(Cells(6, Num_Col)) >= Cells(1, 1) Then
Columns(Num_Col).Hidden = True
Else
Columns(Num_Col).Hidden = False
End If
Next

Step 15: Link the drop-down menus to the macro

To finish the job, we still have to link the 2 drop-down menus with the macro. This way, with each new selection, the macro will be launched.

  1. Select the Combo Box
  2. Right-click on it.
  3. Choose Assign Macro
  4. Select the name of the macro (Hide_Day)
  5. Click OK
  6. Do the same operation again for the second drop-down menu

Now, whenever you select a month or year from the drop-down menus, your calendar will update and the columns will hide (or show) automatically.

Automatic calendar finished

88 Comments

  1. Jamal
    17/02/2023 @ 17:20

    Hi the only problem I have is right at the end, for e.g. if I fill the cell for one of the days in February, then change the month to March I can't see no content which I want. However after I click on March and want to go back to February all my content disappears, which I don't want. So basically if I populate info for any month and the click off and come back to that month, everything that I populated it with disappears. Is there anyway to over come this.

    Reply

  2. Allen
    17/02/2023 @ 15:13

    My days don’t change? What did I do wrong?

    Reply

  3. konstie
    24/11/2022 @ 18:38

    so i have reached the point to highlight the public holidays.
    now i want a different column to count how many workdays each employee has. i used the code =COUNTIF(D10:AH10; "O") and i mark with an "O" each work day of each person. but what if i want to count working weekends and working holidays separately? so that when i fill in the calendar i can see how many sundays and saturdays each employee has to work?

    Reply

  4. Celine Moutic
    17/11/2022 @ 19:48

    Hi Frédéric and thanks for this very helpful tutorial!!
    I just have one tiny issue which I hope you can help out with >> When I want to add little "x"s to the month of August for a specific employee, for instance, I see that the "x"s also appear in all the other months as well. How can we restrict that the "x'"s only show in the month of August?

    Thank you so much in advance!!

    Reply

    • Frédéric LE GUEN
      20/11/2022 @ 10:31

      I don't understand your question because the calendar used a single worksheet. So how can you have "x" for other months?

      Reply

      • Vicky
        17/01/2023 @ 10:42

        Τhe "x" are probably the text that an employee works on 1st of august for example. How can we make that information follow the spesific date and only show up on the 1st of august 1st employee cell ?
        now whatever you type on one month stays there for all months . we need to save the month and go to the next one starting blank, is that possible?

  5. Aldrin C
    07/08/2022 @ 06:11

    Thank you for this. But how can i change the Weekend. here is Saudi, our weekend is Friday and Saturday.

    Reply

    • Frédéric LE GUEN
      18/08/2022 @ 14:45

      I see, Change the WEEKDAY argument to 5 or 6 (I don't remember exactly) and it will work

      Reply

  6. Hiren
    07/07/2022 @ 11:10

    Thanks for the tutorial. I managed to finish all except the last 2 steps... could not get the proper understanding on how. to....

    Reply

  7. kaila
    12/05/2022 @ 21:51

    I will say that the macro does not work if you aren't sure what you're building. Especially since you can't see the full workbook they are using. I've just skipped the macro entirely and just made the text white.

    Reply

  8. Lisa Nieth
    10/02/2022 @ 18:05

    Thank you for the tutorial. I was able to create the calendar, but would like each cell to have a drop down box with a list of options for employees to choose from. If I do Data Validation and create the list for the cells in the calendar, it works. However, if I enter a choice from the list for Feb 10, it keeps that selection for the 10th of every month. How can I make my list in the calendar cells not repeat into other months? I'm not an excel expert and don't know how to figure this out without assistance.

    Reply

    • Asdfy
      14/03/2022 @ 01:54

      Yes, because the calendar is in the same place ... every time you change the month from the drop-down menu, a macro is activated which deletes the data and changes the month according to your choice, but in fact it happens in the same place.
      You can try like that... Make a calendar for the whole year, after just change the code like that

      Sub Hide_Day()
      Dim Num_Col As Long

      Num_Col = 365 'The amount of columns needed for all months of the year

      For Num_Col = 2 To 365 ' I assume the Calendar will start from B. You will need a Column for the Names of the Workers

      If Month(Cells(6, Num_Col)) = Cells(1, 1)
      Columns(Num_Col).Hidden = False
      Else
      Columns(Num_Col).Hidden = True
      End If
      Next
      End Sub

      Reply

  9. shashi
    07/11/2021 @ 06:41

    macro is not working. Pls help

    Reply

  10. Hisham
    15/09/2021 @ 15:34

    Many Thanks

    Reply

  11. Lilian
    27/08/2021 @ 15:20

    Thanks for this, very clear and i succeeded in creating the calender. However how do I let the data keyed on the field do not disappear once the month change? Do you already have the data to share?

    Reply

    • Frédéric LE GUEN
      01/09/2021 @ 14:12

      In fact, your question is more "how to save the value for each month". And the answer is "not possible with Excel". Have a look at Microsoft Planner in your Office 365 account.

      Reply

  12. Malena
    06/07/2021 @ 12:13

    Hi
    let's say the calendar starts at 28th and ends with 27th. Ex. from 28th feb 2021 to 27th marts 2021 but the row continues to 30th, and i want to hide 28th, 29th and 30th.
    is it the same code or do i have to change a little bit?

    Reply

  13. A
    07/11/2020 @ 13:59

    Great guide. I know this is an older post but having trouble with countif and dates of holidays. I am trying to make a calendar for scheduling during critical days and to quickly see if employee time off during holidays conflict with each other.

    Reply

  14. Haris Awan
    03/11/2020 @ 22:53

    Hi, I'm having difficulty in the macro coding. it showing error *COMPILE ERROR* SYNTAX ERROR
    Can anyone assist me with it ?

    Reply

  15. Exar
    26/11/2019 @ 01:46

    Hi,
    Thank you for this tutorial.
    Would you mind sharing how you go about to saving the data from month to month without it being cleared?

    This template becomes extremely useful with the ability to retain data.
    Thank you again.

    Reply

    • Frédéric LE GUEN
      26/11/2019 @ 15:02

      Hi, Thanks to appreciate my article but I can't reply to your message just like that. It's a full development here because if you want to display the previous result, that means that each cells have formulas to collect the previous result (this formula is not easy and depend of the contexte of each worksheet). And of course, if you update one value in the calendar, you will delete the formula. I hope you understand the complexity of a such project. I can but it's a development (2 or 3 days for me)

      Reply

      • Hussain
        31/12/2019 @ 01:02

        Dear Mr. Frédéric LE GUEN

        Thanks for this beautiful explanation
        I followed your step-by-step explanation, and the result was beautiful, but when I return to a month in which the days are 30 days or 31 days, the days remain hidden.
        Please, if possible, attach the calendar file. I will be appreciated you.

      • Frédéric LE GUEN
        03/01/2020 @ 06:37

        There is a problem with your macro for sure. Probably the row for your days is not the one mention in the code.
        Have a look at this link to understand the code and also to customize it.
        No, I don't share the file. It's not the way to learn how to use Excel

Leave a Reply

Your email address will not be published. Required fields are marked *