calendar

  1. L

    Auto recognize weekends with month as row/day as column?

    Hello, I have a worksheet set up like this for us to paste in data we get from a daily report, and at the end we will have some percentage calculation, however there will be some columns with no data since they are weekends. Is there a way for excel to recognize those in this format and put a...
  2. R

    Calendar help

    With the A1 cell name equalling the name of a month how can I get the A2 cell to give me the first day of that month? or if easier I just need a calendar that will allow me to change the cell dates by changing the month in A1.
  3. J

    Day calendar referencing array with duplicates

    Any help would be appreciated. I have a dynamic table of dates. Each column references entire production cycles and each row the cycle stages, with the top row being the start and the bottom the end. I am trying to create a "day calendar" on new sheet with the first column listing every day from...
  4. L

    Find/Return highest value from a variable combination

    I have 13 slots/cells that can host 30 different values. Meaning that I have 1.59432E+19 possible combinations. Is there any way I can find out the highest value of the "Avg Games per week during playoffs" possible?
  5. P

    Find duplicates within a calendar Google Apps Script

    Hello all, I have the below code and I want if it possible to check if the event at the calendar already exists. If yes then dont make a duplicate event. If not create it. VBA Code: // Δημιουργία Μενού function onOpen(){ const ss = SpreadsheetApp.getActive(); const menuEntries = []...
  6. P

    Find duplicates within a calendar VBA

    Hello all, I have the below code and I want if it possible to check if the event at the calendar already exists. If yes then dont make a duplicate event. If not create it. // Δημιουργία Μενού function onOpen(){ const ss = SpreadsheetApp.getActive(); const menuEntries = []...
  7. N

    Cross referencing dates

    I'm trying to set up data table to conditionally format a calendar. The calendar I was trying to use is a formula based one that adjusts the dates and shifts weekdays as the year changes. What I want to do is have a data table to enter specific dates and have the calendar be conditionally...
  8. G

    Excel auto update into calendar in outlook

    Hi, The company I work for manage a holiday log through excel and have asked if it is possible to automatically update this information into a shared outlook calendar. The spreadsheet contacts a list of dates along row 4 (E4:NE4) one column for each date. And a name for each person in the...
  9. C

    Alternative to conditional formatting for project management calendar

    Creating a calendar to be shared with multiple teams. I wanted to use conditional formatting to show whether a project was not yet started, in progress, or complete, as well as color-code tasks. However, it was way too many conditions and started crashing my workbook. I'm trying to see if there...
  10. V

    Coloring of cells based on date within a range

    I want to assign a color to a cell based on there being an event that falls within a specific date range. As shown below, event1, falling within the week of July 4, would cause F3 to be blue, since it has category1. So the cells in range F3:I5 would be colored based on a running list of events...
  11. pedrowave

    New Rolling Calendar Control

    In old versions of Excel there was an add-in for a DatePicker Calendar Control that allowed dates to be entered into a cell from a monthly calendar. New versions of Excel don't include a DatePicker add-in out of the box, so add-ins have been developed by third parties to fix its absence, and...
  12. H

    Calendar Data to Input to Excel like Outlooks built in scheduling form

    Hey There is there a way I can create something similar to the outlook Calendar input form that I can use for budgeting analysis on my excel spreadsheet? Is it crazy hard? Would this need to be done with User forms? Is there an alternate method you would suggest? Thanks in advance! Kind...
  13. 1

    Salary calculator in monthly calendar

    I'd like to keep tabs on what I make. I'm working part time as an hourly employee. I'd like to just have a monthly calendar in excel for each month and just input when I come and leave, and have it calculate the earnings that day and tally it up at the end of the month. The thing is I'd need it...
  14. T

    Which funtion, or VBA?

    Okay, I am beginner/intermediate Excel user for work. Working with Excel 2010. I have a thought process in my head for what I want to happen, but cannot figure out how to execute it. I am tracking employee attendance over a 12 month rolling calendar. Here is my spreadsheet; Basically I have...
  15. P

    Can someone tell me what's wrong with my code? For loop

    Hi, can someone have a look at the code below. It's long, but repetitive. Each IF statement works but only for the first IF comparable, and the ELSE. All of the ElseIF's don't seem to be working and I can't figure out why. Trying to spruce up the holiday tracker for my workforce. Column "AS"...
  16. M

    Creating calendar with month and date change on button click

    So I am trying to create a sort of month view: I have manually typed in the dates, and working hours each day. I have also added a button on the right side. How can I change month by using the button, and automatically change the dates so I can fill inn working hours for the next month?
  17. L

    Gantt Chart

    Hi. I have created a dailywise progress report of a project using conditional formatting. The project is of approx 6 months duration. The project being a lengthy one, it is not possible to print the whole progress in a single page. For that purpose, I have created a dynamic calendar showing 12...
  18. R

    How to best create a calendar and be able to insert traffic light colours in each cell?

    I have asked to produce a system for team members to log their availability to help out using a traffic light system. I am hoping a template already exists where there is already a calendar, say one worksheet for each month in the year, then a column can be inserted to the left for team members...
  19. M

    Setting custom Calendar messes up formulas

    I am building custom Calendar in PowerBI. For Month number I used the following formula: =dDate[Date].[MonthNo] I got month numbers. After creatin several more collumns I marked the table as a date table and all collumns turned to errors. The error message i got from PowerBI: Column referebce...
  20. P

    VBA script to post/update/delete calendar items into sharepoint calendar

    I am looking for a script to post/update/delete items into a sharepoint calendar. I found a working script to make new lists on sharepoint but my knowledge of vba is not big enough to work on a solution to let it work on a calender list. Public Sub PushSPList() Dim lname As String, guid As...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top