calendar

Is there a way of putting the date column into a matrix that is not a hierarchy, I can do this using the date column from the fact table, but would prefer to use calendar table as I've gone to the trouble of making it, essentially the left , which uses the calendar table to look a bit more like...

I hope I've got my row / filer the the right way round, I created two measures one using the dates from the fact table the other from the calendar table RTM using C = VAR mcdate = MAX('Calendar'[Date]) VAR anser = CALCULATE([Tsales],FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<= mcdate))...

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

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.

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

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?

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

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

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

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

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

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

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

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

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

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

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

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?

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

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