Forum Discussion
AUTOFILL SPECIFIC DAY OF WEEK DATE IN CELL
Hi szekeresz,
there is an option to add a shared calender in the New Outlook.
You can add a shared calender by clicking on the Calender icon in the left menu, then by clicking on Add calender button.
After that, click on the Add from a directory, choose your account and choose a person, group or the resource which shared calender do you want do add.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
If that's not the answer you're seeking, please come back and explain more fully; it would also be helpful if you could describe briefly the whole purpose of the workbook.
- Thank you for the help and response. If the first of the month is a Monday the formula will look for and place the Wednesday and Saturday dates in the appropriate cell. The month of February has Feb 1 falls on a Wednesday so I would want the formula to put that date in the D3 cell; In March the first falls on a Wednesday as well; Please look at April. The first falls on a Saturday So I would need the D3 cell to have the first Wednesday Date of 04/05/2023 and the first Saturday date of 04/01/2023 to be put in Cell I3. D9 would be 04/12/23, D15 04/19/23, D21 04/26/23 which is each Wednesday in April, and I3, I9, I15, and I21 would have each Saturday date of April.
Please don't give up on me. Thank you again for your help and expertise.Here's a formula that will return the date of the first Wednesday of any month in any year.
=LET(FstDa,DATE(CurrYr,CurrMo,1),FstDa+CHOOSE(WEEKDAY(FstDa),3,2,1,0,6,5,4))
That formula requires a relatively new version of Excel (in order for the LET function to work).
If you don't have a new enough version of Excel, this formula will work:
=DATE(CurrYr,CurrMo,1)+CHOOSE(WEEKDAY(DATE(CurrYr,CurrMo,1)),3,2,1,0,6,5,4)
In those formulas, you can substitute cell references containing the current year and current month for the text reading "CurrYr" and "CurrMo" or -- preferable -- use named ranges.
I've attached a spreadsheet with both of these formulas working. I'll leave it up to you to complete the rest of your spreadsheet.
mathetes can you assist with a formula to fill columns with dates for only Monday and Thursday every week.
