Hi there! I'd be happy to help you with your sales run rate calculations.

To calculate the monthly run rate based on today's date, you can use the following formula:

1. =SUM(YTD Sales/(TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1)*DAY(EOMONT H(TODAY(),0)))

Let me break down this formula for you:

- YTD Sales: This is the total sales for the year up to today's date. You'll need to replace this with the cell reference for your actual YTD sales figure.
- TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1: This calculates the number of days from the first day of the current month to today's date. For example, if today is June 15th, this part of the formula would calculate 15.
- DAY(EOMONTH(TODAY(),0)): This calculates the total number of days in the current month. For example, if today is June 15th, this part of the formula would calculate 30 (since June has 30 days).

Putting it all together, this formula will give you the monthly run rate based on today's date.

To calculate the quarterly run rate based on today's date, you can use a similar formula:

1. =SUM(YTD Sales/(TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY())-MOD(MONTH(TODAY())-1,3),1)+1)*DAY(EOMONTH(DATE(YEAR(TODAY()),MONTH(TO DAY())+2,1),0)))

Again, let me break down this formula for you:

- YTD Sales: This is the total sales for the year up to today's date. You'll need to replace this with the cell reference for your actual YTD sales figure.
- TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY())-MOD(MONTH(TODAY())-1,3),1)+1: This calculates the number of days from the first day of the current quarter to today's date. For example, if today is June 15th, this part of the formula would calculate 46 (since the first day of the current quarter was April 1st).
- DAY(EOMONTH(DATE(YEAR(TODAY()),MONTH(TODAY())+2,1) ,0)): This calculates the total number of days in the current quarter. For example, if today is June 15th, this part of the formula would calculate 91 (since the current quarter ends on June 30th).

Putting it all together, this formula will give you the quarterly run rate based on today's date.