calender

  1. dss28

    Capturing data in rows for number of days selected in calender

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

    Conditional formation in planing calendar

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

    how to get Date Picker in userform

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

    Extract specific numbers from a text string, and extract range

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

    Date/Calender formula

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

    Producting calender from list or vice versa

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

    [Excel 2010] Formatting calender depending on list of dates

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

    Calender project

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

    Prorate Rent

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

    VBA Code that Sums on a Loop Based on Criteria and Linked to Calender

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

    I would like to create a visual calender that you can click to acess certain data. ??

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

    User form and date

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

    Calendar which auto populates

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

    Calender control 12 size changes

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

    Highlight current date cell

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

This Week's Hot Topics

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
Top