calendar

Afternoon! I've been working on a visual calendar recently and have ran into a roadblock. Basically I've got a spreadsheet where column B has names of employees and columns C/AG are in a table format showing a calendar. I'm using a formula in conditional formatting to display days that employee...

Hi and thank you for considering my problem... I am receiving from Access an error message....data type mismatch in criteria expression The crazy thing is that I have run this before and not had a problem. I am trying to make a make table query for a union situation. I have three queries I...

Hope someone can help – I have been struggling with this for ages! I have a formula with a multiple IF/AND statement incorporating dates and I just can’t get it to work. The conditions are as follows – A1 must be greater than 0, A2 must have YES entered, A3 contains a date which must be within...

I have a cell (B3 to be precise) that I manually input the current month and day 1. In other words, I type into this cell for the month of June as follows: 6/1/2019 (actually because we are in the year 2019 I do not even enter 2019 when typing as it auto appears after hitting the enter key...

Good Afternoon Mr. Excel, I'm hoping someone can help me on here. Have a good knowledge of excel & have been using it for years. I'll explain what I'm trying to do. Would like to open an excel workbook and see a calendar. This calendar will be linked to a single "sheet". I would like to apply...

Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...

Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...

Hello Guys, I am looking for help with a formula, I have a spreadsheet, it’s a calendar and it is laid Out like this: January is on sheet 1, February is on sheet 2 Up to December on sheet 12 The Days are in a column B11 to B41 The Dates are in a column C11 to C41 It’s like this on all sheets. I...

Hi everyone, I'm trying to create a color coordinated (heat mapped) calendar based on 3 years of previous data which will help my team members choose the "less intensive" days to take their OOO. I have my data scrubbed into days, months, and years for all 3 years but I don't know how to create...

I have four columns. A is calendar month, B is calendar year, C is Fiscal month, D is going to be Fiscal year. Our fiscal year is April to May, April = Fiscal month #1 , May = 2, etc. I need a formula for the fiscal year that will look at the fiscal month cell. Say C2 is either 1,2,3 fiscal...

Please help! I have been trying to work this out for the last couple hours and I haven't figured it out. Here is a link to my Facebook and Twitter where you can see a screenshot of my Excel workbook. https://twitter.com/Love4Parrots...

Thank you in advance for your help. Please see Excel image here: https://m.facebook.com/story.php?story_fbid=2468765073152417&id=100000568443530 I am creating a payroll calendar with 3 types of clients: weekly, semi-monthly, monthly. I believe I need conditional formatting with a formula...

February 1 has an Excel serial number of 43497. (fairly easy to figure out) Made a simple calendar based using the day function. =day(43497). Just copied it as necessary using the previous day +1 All is fine. Trying to use Conditional Formatting for today. It works, but when I apply it to...

Hi all, I am trying to familiar myself in Power Pivot window using CALENDAR AND CALENDARAUTO to create a Date table. How do I go about this? Thanks

Hello everybody. I'm grasping data in the web via Excel. I'm stuck in inserting a date in a calendar: how can I write the desired date in this one? <td class="Input" style="width:100%;"><span id="Date1_dateInput_wrapper" class="riS RadInput RadInput_Black"...

I have a calendar table with a column WorkingDay that has a 1 for working days and 0 for weekends and holidays. A typical helper column to get business days would be: Business Days from Approval to Dispatch= CALCULATE ( SUMX ( Calendar, Calendar[WorkingDay]...

I Have one table of calendar in the query simply dates. another table of projects and start date of the projects. I wish to choose the project and then get in the calendar table another columns that compare the chosen project start date to the date in the calendar/ I could not find any way to do...

Hello Forum: I have a somewhat complicated question. I have 4 sets of dates that I want to color code on a calendar in Excel. Set 1 Set 2 Set 3 Set 4 1/1/2014 1/5/2014 1/22/2014 1/31/2014 5/5/2015 5/5/2015 6/5/2015 8/5/2015 9/9/2016 10/2/2016...

I'm creating a worksheet calendar and would like to hide the dates that are not in the current month. For example, in my my January calendar I would like to show a blank cell where the Sunday and Monday dates of Dec 30 and Dec 31st don't appear (i.e. the cell is blank). I would also like the...

I have a macro enabled workbook that is used to manage room(3) allocations. I would now like to upload to a google calendar. I understand that goggle calendar requires a .csv file format. The main worksheet, Year 2019, is made up of many rows for the complete year (>2500) e.g. 01Jan19 to...