CODEWITHSUNDEEP
excel
trebleCode
trebleCode

Reputation: 2308

Upcoming Dates in Excel

I have a workbook with two worksheets, one is Master List and the other is Summary.

On the Master List sheet, columns O, Q, and S contain ticket numbers. Columns P, R, and T contain the ticket date.

How could I use a formula or function that would allow me to do the following:

On the Summary tab, pull ticket numbers and dates where the date falls within the current week?

Upvotes: 0

Views: 45

Answers (1)

Linga
Linga

Reputation: 955

Use the below formula to get the current week dates. And try using vlookup or Index (match (), match ()) function to get the respective tickets.

Sunday of this current week:

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

Monday of this current week:

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

Tuesday of this current week:

=3-WEEKDAY(TODAY())+TODAY()

Wednesday of this current week:

=4-WEEKDAY(TODAY())+TODAY()

Thursday of this current week:

=5-WEEKDAY(TODAY())+TODAY()

Friday of this current week:

=6-WEEKDAY(TODAY())+TODAY()

Saturday of this current week:

=7-WEEKDAY(TODAY())+TODAY()

SUNDAY of following week, when Monday & not Sunday is used as day #1 of week:

=8-WEEKDAY(TODAY())+TODAY()

Upvotes: 1

Related Questions