calendar

  1. W

    If/AND formula - calendar month from today??

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

    Date Functions

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

    Calendar - linked to a spead sheet

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

    VBA to open selected calendar item and add recipient

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

    VBA to open selected calendar item and add recipient

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

    How to Auto Fill a calendar up to today’s date Calendar ?

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

    Need to create a "heat-mapped" calendar based on previous years data for planned OOO.

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

    Formula if one cell is within a range of numbers to return Year from next cell

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

    HELP! Highlighting payroll dates, multiple criteria, vlookup, conditional formatting

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

    HELP! Need Conditional Formatting with Vlookup; Possible If/Or Statement?

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

    Conditional Format today in a Calendar

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

    How to create date table using calendar and calendarauto

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

    Grasping data in the web: how to write in a calendar

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

    Working Days measure without helper column?

    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]...
  15. D

    datediff

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

    Color coding dates on a calendar in Excel

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

    Easiest Formula to hide dates not in a monthly calendar

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

    Dynamically updating / changing CSV files from an Excel worksheet

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

    DATEADD not working

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

    cell formula to get storage rate

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top