| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare numbers based by day of the week and month
Hello, I have to compare numbers based on day of week, since there are many fluctuations between weekdays and weekends.
I have a spreadhseet for March and April, and would like to compare the first Monday of the month in April to the first Monday of the month in March, and so forth. For example, I know have data for two months, and have formatted my spreadsheet so (don't mind it starting on a Friday): Date March April Difference 1st Friday 117 487 370 1st Saturday 1st Sunday 1st Monday 1st Tuesday 1st Wednesday 1st Thursday 2nd Friday 2nd Saturday 2nd Sunday 2nd Monday 2nd Tuesday 2nd Wednesday 2nd Thursday 3rd Friday etc... Is there an easy way to pull the numbers based on the date, which the data already has? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Day, Week or Month | Excel Discussion (Misc queries) | |||
| Print Week Category based on range for month | Excel Programming | |||
| Week of the Month | Excel Discussion (Misc queries) | |||
| Return dates based on month and day of week | Excel Worksheet Functions | |||
| How do I generate a new sheet based on date/week/month? | Excel Worksheet Functions | |||
Threaded Mode
