november

  1. N

    Dynamic Reporting Calendar in Excel

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col...
  2. D

    find the first business day of november of LAST year

    the title says it all
  3. M

    Change how date is converted.

    Hi everyone, first time posting, but I can't seem to find the solution. When I encode 11/3/19 in a cell, when formatted it would show March 11, 2019. I would like it show as November 3, 2019 instead. Is there away to change this. Thank you very much.
  4. C

    VBA - Help!

    Hi, I have the below code which looks for any dates from current year in column B and deletes those rows. Every time I run this code it will be on data from a specific month but could be different years (so always November but could be November 2000 all the way to November 2019). It seems to...
  5. J

    Convert 8 columns to two columns

    How do you convert the following <colgroup><col><col><col><col><col span="2"><col span="2"><col></colgroup><tbody> September 5 1 2 3 4 5 6 7 8 September 12 6 8 5 7 2 4 1 3 September 19 5 4 1 8 7 3 2 6 September 26 3 6 7 2 1 5 8 4 October 3 7 1 4 6...
  6. wrightyrx7

    Is date within a date range (VBA)

    Im trying to think of the best way to check if a date range contains 01 November. If it was a static date i would just use <= AND >= on the start and end date. However, this is just 01 November with NO set year. If the 01 November is within the Start and End date (including the start and end...
  7. S

    IF & MIN via DATE - HOW TO Calculate?

    I have 2 columns. Date and # of Safe Days The Date is starts on November 1 and is sequential through 2020. The Safe Days column represents a 1 or 0 0 = Not a Safe Day 1 = Safe Day I'm trying to figure out a calculation that will automatically give me the number of days since our last safety...
  8. S

    IF & MIN via DATE - HOW TO Calculate?

    I have 2 columns. Date and # of Safe Days The Date is starts on November 1 and is sequential through 2020. The Safe Days column represents a 1 or 0 0 = Not a Safe Day 1 = Safe Day I'm trying to figure out a calculation that will automatically give me the number of days since our last safety...
  9. E

    Formula =TEXT(2017-11-03, "mmm") returns "00", I was expecting "November"...

    Hi all, This feels like a silly problem but I just cannot work it out... :eeek: I want to display the month name in one cell by using the date in another cell. By googling I found out that the TEXT function should be able to this according to =TEXT(A1, "mmm"). However, when I apply the...
  10. M

    Calculate from Sub-data set (by Modified file)

    I have a scenario where daily report file copy in my folder by date and this file are connected to my Power BI report (Folder extract) . how I can calculate the difference data from two different files. Example if I want to calculate data from 1st November till 02 November what formula I should use.
  11. N

    Automatically Insert Data Between Sheets

    I have a dashboard file with two sheets of data. Sheet 1 contains the manually inputted dataand sheet 2 contains two tables summarizing the data from Sheet 1. Sheet 1 set-up: A B C D...
  12. Z

    Formula ? Change on 15th of every month

    HI, Trying to see if this possible. I have so many different sheets. I need something to change the 15th of every month Right now i have this =Sheet2!C4 So on November 15th i need it to pull this =Sheet2!C5 Dec 15th =Sheet2!C6 Only this change would be the number. Possible?
  13. D

    Creating Query of Weighted Averaging Across Tables

    Hi there i have multiple tables all in the below format only much more data about 2000 rows and 200 columns. Column A describes the day for which each following month (column) was priced. I currently have all the data for the peak table and off peak table. I am looking to create the query to...
  14. R

    Sum based on Date

    Hi Need some help here I want to be able to find the sum of November 1 to say the 12th day of the month (will automatically update based on what day it is today) It should total $406,489.97 And then say tomorrow when I check it should total to $432,186.95 <style...
  15. F

    FIFO stock valuation

    Hi everybody, I am trying to work out a way to calculate the value of inventory assuming the earliest inventory received is issued out first. I have pasted in a sample dataset below as a guide. Per the below, the fuel issues on November 1st and 2nd would be costed at $0.90, and the issue on...
  16. R

    Display the number of times a specific day appears between two dates

    I need a formula to find all the occurrence of Nov. 1 (11/01) as a string between two dates. For example: Start date: 11/05/2014 End Date: 11/05/2018 Date to list: Every November 1st Result: 11/01/2015, 11/01/2016, 11/01/2017, 11/01/2018 Thank you in advance :)
  17. 4

    Dependent Drop Down List

    Hi Everyone, So I have been having an issue with figuring out the best way to display some data after some user input through a drop down list. To give you an idea of what I want I currently have in mind as an end result, this is what I would like it to look like in a word document or excel...
  18. V

    Transpose range of cells based on the whether a cell repeats

    I have an input sheet with a lot of names in Column A which repeats (Maximum 3 times) and rest of the cells (from column C) are different. I need to generate a sheet with unique names and rest of the cells transposed. INPUT SHEET Employee ID Date Of Joining Effective Date...
  19. J

    Calculate 4th Friday from a date

    I need to collect forms from many departments. I want to give each department 3 weeks to a month to return their forms. I would like calculate 4th Friday from the date I asked them to fill the forms. For example, if I asked them to fill the forms on November 20th, then they should get the forms...
  20. A

    Auto Fill Dates

    How can I "drag" down dates formatted as below to auto update? <tbody> November 2016 December 2016 January 2017 February 20217 March 2017 April 2017 </tbody>

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