calender

Hi I need a formula to create entries in a calendar In worksheet named "Input" if I enter a detail column B named Event 1 (against in against Column A10 in date 08-May-24) then the output of that be automatically be listed in worksheet named Table in E9. Similarly all empty columns should have...

Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...

I want to build a data base using a userform1 having say 4 textboxes to input data textbox1 - Name textbox2 - address textbox3 - Start date textbox4 - end date the sheet1 where data will be saved will have columnsA as Name, ColumnB as Address, ColumnC as Date. I want to capture data in sheet1...

Hi Forum, I'm reach out to you to ask if someone can help suggest improvement to a function for conditional formatting. I created a calendar where I can plan resources by entering the number of days and the following cells are colored by using conditional formatting. This far I have only...

Can somebody tell me how to get the calender control in the UserForm? I don't find it in my additional tools

Hello, this is a bit of an odd query, I am trying to convert a student timetable into an excel spreadsheet (then create a calendar with it), but the data I have been given is in an awkward format. It would be easier to give an example: I recieve a cell containing a list of weeks a certain class...

Hi, I am trying to make a formula that take a certain period of time (M-1, M0, M1, M2, M3 and M4) So the previous month and 5 month ahead. I made a similar code for the past 6 month...

Morning all, new user here :) A team utilises a spreadsheet laid out in a calender format similar to the following <tbody> Customer 22/2 23/2 24/2 25/2 26/2 27/2 28/2 1/3 ... A Job 1 Job 2 B Job1 & 2 Job 4 ... </tbody> But my job would be 1000x easier for all...

<tbody> dates M T W T F S S 01/27/2017 16 17 18 19 20 21 22 01/28/2017 23 24 25 26 27 28 29 01/29/2017 30 31 1 2 3 4 5 02/02/2017 6 7 8 9 10 11 12 </tbody> Hey! All I want to do is to highlight every day in the primitive calendar on the right that is stored on the left in the...

Hi guys, I've recently started working offshore and to kill some of the time I have I thought I'd try and create a comprehensive calender that tracks the following. vessel worked on sector worked in eg UK, US, Asia days worked I'd like to have a calendar that is perhaps linked to a...

Hello. Help needed... I am trying to create a formula to determine the amount of rent due for not only the start of the lease but for the full term of the lease itself.. For the following problems I would like to have a formula that could be utilized over and over again. Lease Starts On...

Hi guys, What I'm trying to do is too complex for a regular Excel formula, so I need a VBA. Unfortunately, I know very little about VBA, so I'm really counting on this forum. I think this might be a challenging VBA, but hopefully fun too! As it is now, column CH has a formula that takes the...

Excel 10 Noobie lvl at the moment Hey. I am creating a spreadsheet that employees will enter data in everyday. I need to know what is the best way to insert an interactive calender that when you click on a certain date you will be directed to the coresponding data worksheets for that day. Any...

Hi, How can i enable my user to go into user form and choose a specific day from a calender ? i allready have the user form i just cant find the calender in order to deploy it in the from. Thanks, Aviad

Dear Community, Been using your forum for a long time and decided to make my own account today to post my first question, to which I did not find an answer which worked for me so far... So here my problem: I have a list of items which all mature on different dates and all have a certain money...

Hi I was wondering if anyone could help me a problem, I have created an Expenditure sheet showing my monthly bills. I have placed a calender Object on the sheet. I have reduced it to a certain size so it fits in a certain position, and in design mode it fits but when I come out of design...

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am working on a calendar where I need the current day to be highlighted. I know how to do it with conditional formatting but I would like to use VB for it. I have come up with the following code but...