Hi. I am new to this forum. I have been around on other excel forums, but as nobody ever replied to one of my questions, I'm trying again here...
I am looking for two formulas.
The first one:
A formula I can use for making a "dragable" row of all mondays, tuesdays, thursdays and fridays of one month.
In the other formula, I want mondays, tuesdays, wednessdays, thursdays, and fridays.
For now I use this formula:
=date("cell with year";"cell with month";"cell with day")
The problem is that I don't want any saturdays or sundays.
In the other spreadsheet, I don't want any saturdays, sundays and wednessdays.
Can anybody help me out on this one?
Bookmarks