jun

  1. M

    Counting occurrence of date in date range being string format

    I have a date ranges as per below. one range per cell. in the next column i have month and year from any of the below ranges. i.e Oct 2019 I need to count occurrence of of Oct 2019 in the third column in the row corresponding with the actual range, which is Oct - Dec 2019...
  2. P

    VBA create dynamic graph from two columns

    Here is my problem I have a user form contains a ListBox that been populated from column A. It's ok fixed that. I have 3 commandbuttons (TEMP, HUMIDITY,RAIN) and one PictureBox. I'm trying to create a graph that contains x axis= Jan, Feb, Mar, Apr, May, Jun and y-axis the values from cells...
  3. R

    Need a Formula to Lookup the week number that a day falls under between two dates

    <colgroup><col><col span="4"><col span="9"><col></colgroup><tbody> Week Day Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat From: 28 May 17 29 May 17 30 May 17 31 May 17 1 Jun 17 2 Jun 17 3 Jun 17 4 Jun 17 5 Jun 17 6 Jun 17 7 Jun 17 8 Jun 17 9 Jun 17 10 Jun 17 To: 28...
  4. H

    Need axis to display individual days of the week...

    Hi I've got an Excel (2013) Gantt with the following Axis settings (which already display the date, however, not every single day which is what I need): Bound Min 42020.0 Max 43510.0 Unit Maj 10.0 Min 1.0 vertical axis crosses - automatic Display units - none. Which boxes do I change in order...
  5. P

    Same period formula

    I have two table of sale data datewise one for 2015-2016 and another for 2016-2017. In our retail chain bussiness some new location add or closed in 2016-2017. Now when i want to compare someone location with last year then what i do for sameperiod sale. Suppose xyz opened in 14 jun 2015 and...

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