calendar

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

I have this automatic calendar that goes from January 1st 2019 to January 31st, I am required to create a VBA code or otherwise to select a date range at any point in this calendar so that it can be copied and placed into another sheet, I already have a macro that I can use to copy it to another...

I'm extremely new to excel, initially I created this program in VBA but after running it, it would take over five minutes to process so I had to start over using Excel formulas. I am familiar with coding that's why I decided to do it VBA but the logic is Excel formulas are so complex to me I...

I'd like to put together a sheet that builds a calendar using data from a table. AND that "translates" the appointment time into whatever local time zone the reader selects. (I'm happy to hard-code the options on the main table.) Here's the deal - I will be traveling in one country while my...

I need a correct formula for calculating accruals and I hope a finance type has something ready-made as this ties me in knots. (I think everyone hates accrual accounting.) We calculate accruals in a somewhat normal accounting way. If I order a $100 widget from Zimmer, we put it on a...

I want to highlight the days on my calendar that match my Event list, but I want the different events to have different colors. example: Event List 1. 1/3/2020 - Baseball 2. 1/4/2020 - Football 3. 1/5/2020 - Golf 4. 1/6/2020 - Baseball 5. 1/7/2020 - Baseball 6. 1/8/2020 - Golf I want the...

I have a form that enters employee's travel plans into an Excel worksheet, including starting and ending dates - one row per travel plan. I want to visualize these plans (start date to end date) in a calendar view in the same spreadsheet. However, I do not want to use VBA, because I do not...

I am trying to add conditional formatting using end of month. What I am hoping to have is this: Enter a date in "A1" Next "A2" has formula "=EOMONTH(A1,36)" I would like to have three conditional formats showing "Green" if today's date is in the preceding calendar month or earlier than "A2"...

Good morning, i am in the process of trying to get a training calendar built which i already have the calendar part done so that when i change the year on first month it updates it for the year. my next task of trying to figure out is if there is any way to auto populate the information for the...

I would like to create a calendar table in the data model to be able to group by week.Weeks are 5 days per week - Monday to Friday. So, my calendar starts from: 8/6/2018 to 7/26/2019 Week 1 starts from 8/6/2018 to 8/10/2018 And every 5 weeks, we start a new week 1. Can anybody, please help...

I was wondering what the easiest way to set up a recurring event on an excel calendar would be? For example I have one month on each tab. On every 2nd Saturday, I want the calendar to say Board Meeting and the cell to be filled with a purple color to stand out. Can someone help with this? And I...

Hello there, I'm hoping to get some advice and guidance on how to start. I used an Excel calendar template, which was perfect because it has a select year option to display all 12 months of the year, then I listed out some dates for events A, B, C to conditionally format it on the calendar...

Hello there, I'm hoping to get some advice and guidance. I'm trying to create a calendar color coded by the event type and the number of hours spent per day. To start, I used an Excel calendar template (it's the most applicable to my situation as it allows users to flip through years and...

Hi Everyone, I have this code that works great But instead of just working for column "CF" I'd like it to do the same but for "CF:CO" how can I get it to do this? Sub TestNames1() Lastrow = Sheets("Project Calendar Raw").Cells(Rows.Count, "A").End(xlUp).Row For thisRow = 2 To Lastrow...

Hi Members I am trying to create a spreadsheet for our tennis club, We may have members that play on multiple teams , on our calendar to schedule matches I would like to be able to restrict the drop downs if a player team is selected then any other team that they play on can not be selected...

Hi Everyone, Wondering if anyone knows how to change the Excel pop up calendar to show the correct month, day & year? The tag at the bottom of the calendar shows Today:5/4/2019 but the calendar itself pops up showing March. I know you can change the VALUE in the calendars property but I don't...

Hi all, I have a worksheet set up with dates that an area is booked for, and a calendar set up on the same sheet. Currently I've got it highlighting the date on the calendar if the date is entered on the worksheet by conditional formatting if values are between cell x and cell y, but what I...

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