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...
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...
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...
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 :)
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 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.