1. 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?
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. lockarde

    Creating a dynamic calendar in Excel

    Good afternoon all, I have a spreadsheet that tracks intakes for my office. These intakes have due dates, and I would like to have a calendar automatically update with the information under "Action Title" column based on the due dates. Here's what my sheet looks like with all sensitive...
  7. E

    Dynamic task calendar that accounts for holidays

    I'm developing a dynamic calendar (not shown) that sources its tasks from a task schedule (see enclosed screen capture). In the task schedule, the user enters the decision date in cell D1 and the task schedule populates the decision date in B13. The other dates are workdays relative to the...
  8. DRSteele

    Create a Dynamic Calendar with function SEQUENCE and some formatting

    Let’s create a dynamic calendar in Excel the quick and easy way. We can use the clever new Excel function SEQUENCE in Excel 365 Insider. Mr. Excel (Bill Jelen) sparked this idea with this video and I enhanced the concept so that all we need is a date to make the calendar matarialise in the...
  9. D

    Camera tool to view a (Changable) range of cells

    I have a workbook set up as a team calendar, the first sheet "Programme" contains all the calendar data with a second sheet "dashboard" containing some calculations. Within "Programme" columns D to NI represent every day of the year and rows 3-32 represent staff, columns A-C holds a list of...
  10. R

    Rolling Calendar Attendance and Tardy Tracker

    I'm trying to help my manager create a spreadsheet to track various types of absences and leave. I've linked the spreadsheet here to see what I have set up, but need to figure out how to extract the right data. I am looking for a way to figure out absences based on a rolling calendar year, and...
  11. U

    Recurring Tasks Calendar

    Hello you all! I've been looking for a way to automate a calendar that I use and as of today I fill it manually. It is a calendar of recurring tasks but they change through the weeks of the year. For example I have tasks that are on mondays every 3 weeks. Others that are monday, wednesday and...
  12. S

    Calendar day coloring

    Good Morning, I had a few ideas but most of them involved recreating the calendar and I haven't done that yet...anyway A user came to me asking about formatting a sheet he's got. The workbook is a simple "Planner" for work tours: He inputs a day, then inputs the number of days he's going to...
  13. B

    Ideas on using VBA to build a calendar to schedule conference room

    I have been assigned the task of creating a tool for use by employees in scheduling a conference room. Does anyone have experience with this who could possibly point me in the right direction? My hope was this could be done using VBA. Thanks,
  14. A

    Resource Management and Planning Software

    Hello, I hope everyone is doing good. I am looking for some recommendations regrading the Resource Management and Planning Software. Is there a software, where I can manage and plan my organizational resources (Like a resource planning calendar). Also, everyone should have access to this...
  15. S

    Figuring out current QTR

    Hi, I thought I had this resolved. But starting in October it thinks November is the current QTR. This is my DAX columns I created in the Calendar table. These are the 3 columns i created =IF(MONTH([DATES])-1=0,12,(MONTH([DATES])-1)) = ROUNDUP ([SORT]/3,0) <today(),if(roundup(month(today())...
  16. D

    Utilize drop down to format other cells

    I'm brand new, and struggling. I want to create a drop down menu for a user building a calendar. For example, when the user selects "Weekend" from the drop down menu, the cells within the calendar day are all changed to gray. When they select "Week Day" then it allows the user to make inputs...
  17. E

    Stock market 15 minute calendar

    Hi, So, I'm having a rough go at it trying to create a calendar without manually entering every 26th row. I am attempting to create a 15 minute calendar for Stocks. For example: COL A 9/3/19 9:30 AM 9/3/19 9:45 AM = WORKDAY(A1,1,[holidays])+15/1440 9/3/19 10:00 AM =...
  18. D

    Syncing w Google Calendar

    Is there a way to put a date/time in a cell in Excel and have that then synced to my Google Calendar?
  19. C

    Calendar Coding Using Conditional Formula With A Color Code Of Users Choosing

    I'm having trouble learning this "loop" feature in vba, or even if it's the correct way to do what I'm wanting. I'm looking at changing the day's background fill, or the "interior". I figured out how to do it one box at time, but it seems as though that probably isn't the BEST way to do it and...
  20. L

    Find date

    Hello Mr Excel, I have a calendar that setup to look like a calendar. I need a normal look formula that could find the first day and the last day of an event. <colgroup><col span="9"><col></colgroup><tbody> sun mon tue wen thu fri sat look up a 26-Aug 27-Aug 28-Aug 29-Aug 30-Aug 31-Aug...

Some videos you may like

This Week's Hot Topics