formula and dates

  1. 2

    Search an array located by referencing a date match

    Hello all; new to the board. I'm really stuck on a problem. I'm trying to write a formula that will be used in conditional formatting. I have a calendar that uses macros and self populates the days when selecting a year using a spin button. I want to conditional format each day to change color...
    • 240racr
    • Thread
    • formula and dates formula array formula as cell reference
    • Replies: 11
    • Forum: Excel Questions
  2. S

    when is my next need date

    hello, Can someone please help me with a formula to see when is my next need date will be? ex: 1st row I have 50 pieces minus each month quantities take away: 20, 20, 10, 10, 0 I need a formula that will calculate how far my stock will cover and automatically put in a date <tbody> product...
  3. B

    Need a formula to calculate a date based on 2 other cells that have dates in them

    <tbody> A1 A2 A3 A4 01 Mar 2006 12 May 2011 01 May 2020 240/108 </tbody> So I need a formula in cell A3 that will produce a date based on the following: A2-A1: if the answer (in months) is greater than 108, then cell A3 should be a date that is cell A2+108 A2-A1: if the answer (in...

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