02/01/2018

  1. W

    Fill down Question.

    This maybe a very simple question. I have 1 column. 01/01/2018 01/01/2018 01/01/2018 01/01/2018 I want the pattern to continue i thought i could highlight the 4 cells and fill down and it would look like the below but it does not let me it just duplicates the values in the first 4 cells. I...
    • Wecks
    • Thread
    • 01/01/2018 02/01/2018 03/01/2018 cells fill down
    • Replies: 1
    • Forum: Excel Questions
  2. T

    Sum with criteria

    Hi I have a column of dates which cover several years in the format 01/01/2018, this column is modified with dates added to and removed regularly. I wish to be able to search for a particular year and then sum all the unique dates in that year without counting the same date twice and also only...
    • Tikey
    • Thread
    • 01/01/2018 02/01/2018 col dates search
    • Replies: 5
    • Forum: Excel Questions
  3. B

    Change formula to perform different calc based on date in another cell

    Hi- Current formula is an easy =IF(F6,(G6*$H$2),"") Need to change it to =IF(F6,(*check date value in F6; if prior to 02/01/2018 then (G6*".6"), if after 02/01/2018 then (G6*$H$2),"") Can someone help me with this? thx!

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