Jennifer

Weekly Sales Projection / 7 * weekday(today())


Weekday(Today())
returns 1 for Sun & 2 for Mon etc

Mike


"Jennifer" wrote:

Hello!

I have a formula that I manually change each day, but I'm betting I can set
it up to change for me when I change the date at the top of the worksheet...

Weekly Sales Projection / 7 * [# Days WTD] Where the # days of the week
will change each day.

So when I put in Sunday's date the formula will see that it is a "Sunday"
and multiply by 1, Monday is 2, and so on.

Any ideas?

Thanks!