calendar

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

HI, I have formula I want to use but it doesn't give me wanted day shift. Masure "Count Of Selected Calendar Days" shows correct amount of days, but when applied within formula it shifts days just for 1 day, not 15, for example). Please advice, thanks CashIn Previous Period =...

Hello, I am having trouble putting this formula together, and any help would be much appreciated. Storage: 7 free calendar days including devan date > $3.50 per cbm, or $50 min charge for next 5 days, 12th day - additional $3.50 per cbm per day - no min Cell H4 is a completed date H5 is the...