date ageing

  1. S

    Find Date at Which Open Orders will Exhaust Finished Goods on Hand

    Hello! Company has 2 SKUs. Below is a standard report run on these SKUs. You can see that SKU 2 has enough stock to fill all open SOs (sales orders) but SKU 1 does not. ABCDEF1Item IDQty Per Pallet Qty on HandQty on SOQty AvailableNet Weight 2SKU 154,3806,720-2,340203SKU...
  2. Ferreira1456

    Dates with condition using userForm textBox in VBA

    Hello everybody, can you help me? If I delete the value of txtPrazoPagamento or the value of txtDateVencimento. I get this message: Run-time '13' Type mismatch Private Sub txtDataVencimento_Change() If CDate(txtDataHoje) > CDate(txtDataVencimento) Then txtAtraso.Value = Abs(DateDiff("d"...
    • Ferreira1456
    • Thread
    • calculate date & range date add date ageing date condition dateif dates
    • Replies: 3
    • Forum: Excel Questions
  3. B

    Macro that concatenates two cells, references a Date and then copy pastes value into first available row

    Would love some help writing this macro i've uploaded the file on dropbox with more explanations within the file if it helps make it clearer. (in yellow highlights & red text) dropbox file I have two sheets. One titled 'Money', the second titled 'Data' In the 'Money' tab, there's a section...
  4. R

    Using visualizations for data that involves approaching deadlines

    Hello Everyone, This is my first post here and also my first question. Every week I extract a data set from a web-service that serves many functions. One of these functions involves action plans that the business has to follow. These action plans have deadlines. Is there any way that I...
  5. R

    Excel Formula for Date Ageing with given condition

    Hi Guys, Need help on condition formula for Aging of date with conditions, example below. If Date below with Status = Open, Hold or In Progress populate on Ageing field the following (if 1 to 14 days = <14, if more 14 days but less than 30 days = <30, if more than 30days but less than 45 days...

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