Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function for generating all Mon, Tues, etc for each month
I have a spreadsheet that I use each month. Within each month, I need to have the dates of all Mondays, Tuesdays, Wednedays, Thursdays, and Fridays in that month. Right now, I manually enter each date under the columns corresponding to that day of the week. My spreadsheet right now looks like this:
A30: Monday B31: needs to be the first monday of the month B32: needs to be the second monday of the month B33: needs to be the third monday of the month ... B38: needs ot be the first Tuesday of the month ... Any help would be greatly appreciated. Thanks! |
#2
|
|||
|
|||
Quote:
all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating date from day, month year | Excel Worksheet Functions | |||
Generating New Worksheets Every Month | Excel Discussion (Misc queries) | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Generating a blank worksheet at the start of the month | New Users to Excel |