wmichael
Board Regular
- Joined
- Aug 26, 2014
- Messages
- 113
- Office Version
- 365
- 2019
- 2007
- Platform
- Windows
- Mobile
Hello.
Seeking a formula to extract details from the CURRENT DATE START (E) cell to populate in the MONTH (A) cell and the WEEK (B) cell instead of me manually entering the month and week- appreciate your help in advance. Thank you.
--- Michael
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD]MONTH[/TD]
[TD]WEEK[/TD]
[TD]PAST DATE START[/TD]
[TD]PAST DATE END[/TD]
[TD]CURRENT DATE START[/TD]
[TD]CURRENT DATE END[/TD]
[TD]FUTURE DATE START[/TD]
[TD]FUTURE DATE END[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Oct 1, 2017[/TD]
[TD]Mon, Oct 30, 2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Oct 1, 2017[/TD]
[TD]Mon, Oct 30, 2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Jan 1, 2017[/TD]
[TD]Tue, Jan 30, 2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Jan 1, 2017[/TD]
[TD]Tue, Jan 30, 2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Fri, Sep 1, 2017[/TD]
[TD]Sun, Sep 30, 2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Jul 1, 2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Seeking a formula to extract details from the CURRENT DATE START (E) cell to populate in the MONTH (A) cell and the WEEK (B) cell instead of me manually entering the month and week- appreciate your help in advance. Thank you.
--- Michael
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD]MONTH[/TD]
[TD]WEEK[/TD]
[TD]PAST DATE START[/TD]
[TD]PAST DATE END[/TD]
[TD]CURRENT DATE START[/TD]
[TD]CURRENT DATE END[/TD]
[TD]FUTURE DATE START[/TD]
[TD]FUTURE DATE END[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Oct 1, 2017[/TD]
[TD]Mon, Oct 30, 2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Oct 1, 2017[/TD]
[TD]Mon, Oct 30, 2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Jan 1, 2017[/TD]
[TD]Tue, Jan 30, 2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Jan 1, 2017[/TD]
[TD]Tue, Jan 30, 2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Fri, Sep 1, 2017[/TD]
[TD]Sun, Sep 30, 2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun, Jul 1, 2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>