calendar

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...

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...

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...

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...

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...

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,

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...

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())...

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...

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 =...

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

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...

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...

Hey all! I was wondering if anyone had a VBA code string to embed an outlook calendar into powerpoint. Thanks!

Hi All Greetings, I want to add a start and end date box (Calendar box) in my PowerBi Dashboard is there was of doing it so basically the dash board updates withthe start and end data selected? Example below: Start Date ………………………….. End Date...………………… If anybody...

Hi Everyone, I am trying to create a booking tracker, for example if I input start and end date per guest/room, this days will be highlighted on calendar. One room can have different guest on different dates range. I was using if(and(vlookup, but only able to have first guest info on the...

Hello All, Here is my questions / situation. I'm currently working on an excel spreadsheet that has a date of when a document is filed. Once the date is entered, i have a macro that inputs an appointment into my outlook calendar. Now here is what i need to do. Based on information located on...

Hello, I'm created an outlook template with a macro-enabled workbook attached. When the recipient saves the workbook, the calendar form doesn't pop up in specified cells even after the person had clicked 'enable content' when the warning message about macros popped up. Is this a problem that...

Hello, I have data set where order ID's get created for every purchase transaction, whenever there is a change in transaction same order id gets updated and forms a new row. Now i wanted to distinct count how many orders i received per calendar day where the calendar dates sits out side of the...

Hello, May i seek help for the formula I can use to make a list of activities from the given calendar setting? https://www.dropbox.com/s/tgzz9815ma95cdq/making%20list%20from%20calendar.jpg?dl=0