month in formula

  1. S

    VBA to hide date columns based on user selection in drop-down list

    First post and desperate to stop wasting my time trying to piece together bits of what I need from different searches. I am pretty new to writing code and will admit I don't always understand every line of code I find when searching. I have a timesheet template with date values (properly...
  2. K

    Conditional Formatting the Month with automatic monthly progression.

    GentlePeople, I have a Question about How to get my "month" selection to automatically increment +1 for each new month? I have a few different ways that I have thought it should work, but doesn't. <tbody> Circle the Month: 1 2 3 4 5 6 7 8 9 10 11 12 </tbody> This is the way the month...
  3. A

    Formula to calculate monthly values from weekly time series, using days in each week

    I want to calculate monthly values from weekly ones, by taking into account the number of days in the weeks that overlap each month. Below is an example. Row 5 shows the figures I want to calculate, by referencing the rows above. <tbody> 03/05/2015 10/05/2015 17/05/2015 24/05/2015 31/05/2015...
  4. Smokeyham

    Calculate number of months between start of fiscal year and anniversary month/day?

    Hi, I have a list of start dates for employees (Month/Day/Year). I would like to calculate the difference in months between the month/day in which they were hired and July 1st. For instance, for someone hired August 15, 2010 the difference between July 1 and August 15 would be about 1.5...
  5. A

    How to count the values in Column S if Column E equals a certain month

    Hello, Column S contains different strings of text. Column E contains the date that the information in Column S was decided. I would like to be able to calculate the following two things: Count the number of times the phrase "not eligible" appears in Column S IF the date in Column E is in...
  6. B

    Putting dates into quarters for quarterly report.

    How do I seperate multiple dates into quarters? In EXCEL 2007 I have > 33000 rows of dated data. The dates are unsorted & run from 1/1/2012 to 12/31/2012. I have used the month() formula to seperate these in monthly categories of 1 - 12 & then put the data to a pivot tbl and pivot chart. I...
  7. A

    Using dates in Excel formulas

    I have long table which looks like this: <tbody> A B C D 1 Date Order no. Value State 2 3 </tbody> When I need to get a subtotal of the values state-wise I use the array forumula: ={Sum(if(D2:D200="Name of State",C2:C200,0))} Now, when I use the same formula for a month-wise...

Watch MrExcel Video

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