current date formulas

  1. G

    Conditional Formatting for Various Dates

    I am trying to figure out formulas to create conditional formatting for dates that take into account the current date and its relation to future dates, and that are not limited to specific months, years, or number of days. I would like these formulas to be able to carry over into future years...
  2. L

    Returning a date in a cell, but leave blank if no date entered

    Hi All, I am trying to automate some process and minimise data entry using formulas Does anyone know if you could populate one cell with today date if other cell contain data otherwise keep it blank but to keep day date entry? For example: B1=IF(ISBLANK(A1),"",TODAY()) - how do i keep date in...
  3. G

    VBA - Value and current date input

    Hi all, I`ve checked some forum threads on the topic but could not find one that exactly answers my questions, hence the new post. Basically, looking to create script to open a worksheet from My Documents path. Then change values in cells in a pre-populated worksheet (mostly strings) including...
  4. J

    VBA Code to calculate CURRENT DATE - COLUMN DATE and insert the difference in Another Column

    Hi Mates, I need a Piece of VBA Code to calculate CURRENT DATE - COLUMN(A) DATE and enter the days in Column B Tried with Date Diff Function. But Dont know how exactly to do. :confused: Thanks in Advance :)
  5. N

    Max and average forecast by year numbers

    I am in need of modifying a formula that I placed in a budget report I am working on. The forecast total by max =MAX(E27:I27)*7+SUM(E27:I27) and average =AVERAGE(E27:I27)*7+SUM(E27:I27). Well now it needs to be changed to give me the max and average total of the year which I know will be...

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