I am trying to use the TODAY function to calculate monthly sales based on sales to date, i.e. if today is the 16th, I want to take total sales month-to-date, and extend it to 30/16ths of the sales total.
On 2002-04-16 11:42, scwyj wrote:
Thank you for your prompt reply. The formula worked well. Now that it is working, I am told that our MTD sales are to YESTERDAY, not today.
How can I modify this formula to calculate yesterday's factor?
Note: This formula uses the EOMONTH function which is supplied by the Analysis ToolPak. See the Excel Help topic for "Install and use the Analysis ToolPak" if you need to install this add-in. This message was edited by Mark W. on 2002-04-16 13:52
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.