Forum Discussion
AUTOFILL SPECIFIC DAY OF WEEK DATE IN CELL
I want to put the first day of the month in a cell and then put in a formula that will recognize and put the date of one day of the week in another cell. Please look at the spreadsheet picture for F...
- Your examples are always three days apart, with you entering a Wednesday date and the system generating the Saturday date. If that's all you're doing then the formula in cell I3 would be as simple as =D3+3 and then just format the cell as a short date.
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.
mathetes can you assist with a formula to fill columns with dates for only Monday and Thursday every week.
I modified the earlier formula so it gives you the first Monday in any given month. From that starting point, it's easy to add 3 for the next Thursday, then 4 for the next Monday. And repeat.
