Formula based on Date

J

Jennifer

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!
 
M

Mike H

Jennifer

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


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

Mike
 
J

Jennifer

Awesome! Thanks for the quick response.


Mike H said:
Jennifer

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


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

Mike


Jennifer said:
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!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find next Sunday 7
Search closest day in the past from today 2
Using a Date and corresponding weekday to pull amounts 1
Formula help needed please 2
Expanding Date Formula 0
How do I post date a letter? 1
Testing a cell value for a specific weekday. 4
Use array/braces **WITHIN** a formula? 6

Top