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

Workday Formula to include date 0
Last business day 7
Date formula 1
Printing Dates on One Sheet 5
Displaying the Date#2 1
Use array/braces **WITHIN** a formula? 3
Display "this week" column headers w/date & day of week? 9
Finding the right function & formula 4

Top