| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula based on Date
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula based on Date
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula based on Date
Awesome! Thanks for the quick response.
"Mike H" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Earlest Date Based On A Date Using Min Formula | Excel Discussion (Misc queries) | |||
| Create a formula based on date | Excel Worksheet Functions | |||
| Need to create formula based on date | New Users to Excel | |||
| Need to create formula based on date | New Users to Excel | |||
| Convert formula to value based upon date | Excel Discussion (Misc queries) | |||
Linear Mode
