How To Populate Date Based On 1st Day(Monday) Of The Week?

[xlmaniac]

Dear All,
I do have a data set spread across thousand of rows & the sample of the same is as follows:-

I am looking at formulae across C & D Columns based on the following logic:-
1)Monday of the present week should be populated based on dynamic Today function. The formula should check the Monday of the present week(based on Today, function. Week would start from Monday and end on Sunday.
2)For the next week, the Monday would become 9th, 16th, 23rd & so on based on Today function.
3)Once the date pertaining to Monday has been populated in Column C, then this date should be used to propose the Supply Date for the vendor under Column D.
4)Formulae under Column D should first check the Day(Column B) & then derive the date accordingly in Column. For Row No:-3, there is one supply day on Thursday & hence the formula under column D should populate 5th May, since Thursday(after 2nd May) is 5th May.
5)If there are multiple supply days for any vendor, then the formula should calculate the proposed supply date based on the 1st instance.

For example, for Row No:-4, there are 2 days(Wednesday & Saturday)(Column:-B). But since Wednesday is 1st instance here, so the formula should populate date of 4th May(Column), since Wednesday(after 2nd May) is 4th May.
Similarly for Row No:-5, there are 3 days(Monday, Wednesday & Friday)(Column:-B). But since Monday is the 1st instance here, so the formula should populate date of 2nd May(Column), since Monday is 2nd May.
Pls help.
Thanks

 

[Rick Rothstein]

Here is the formula for the Monday of the current week...

=TODAY()-WEEKDAY(TODAY(),12)

 

[Rick Rothstein]

For your other column...
1) What does "alternate Tuesday" mean?
2) Are there any other non-day names besides "alternate" and "every"?

 

[Phuoc]

Maybe like this:

=TODAY()-WEEKDAY(TODAY(),2)+1

 

[xlmaniac]

For your other column...
1) What does "alternate Tuesday" mean?
2) Are there any other non-day names besides "alternate" and "every"?

Dear Sir,
Thank you so much for the solution for the Column C.
1)Alternate Tuesday means that the supply is planned on alternate week but on Tuesday.
2)There are no Non-Day names beside "Alternate" or "Every".

You can ignore these 2 components(Alternate or Friday) while populating the Day under Column D. I shall remove these 2 and keep only the weekdays Monday to Sunday, under Column B.
Regards