| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to return a value between date ranges
I have one worksheet with 52 rows for each week of the year with the
following headings: week #, start date of week and end date of week. I have another worksheet where I need to forecast expected expenses for new employees based on the date they start ie. Joe starts in Feb 6 (week 6) and then calculate expected spend based on remaining weeks in the year. I do this manually right now. How can I automate this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to change date ranges | Excel Discussion (Misc queries) | |||
| formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
| Return Sundays date of current week | Excel Worksheet Functions | |||
| How do I chart date ranges with varying start and finish dates? | Charts and Charting in Excel | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
