How many days ago was Monday - this week

[PCRIDE]

Hi, I’m building a dashboard and have last weeks numbers (5 days of data) and I need to compare it to this weeks based on the day of the week we are in.

Example, 500 tickets last week
This week is Wed, so based on average we would have 300 tickets up to Wed.

I need a formula that looks at today’s date and day, and counts how many days ago till Monday.

So whatever “today” is, tell me how many days ago was Monday. I need the result to be a number

If today is Wed, then it would produce a 3.

Any ideas? I was trying to use Today() and Networkdays and Text(“dddd”) in many combos and couldn’t come up with something

 

[jtakw]

Hi,

Like this?

Book1
	G
1	5
Return Value

Cell Formulas
Range	Formula
G1	=WEEKDAY(TODAY(),2)

 

[Joe4]

I guess it depends if you want to include Monday or not (is Monday day 1 or day 0)?

If Monday is Day 0:
=WEEKDAY(TODAY(),3)

If Monday is Day 1:
=WEEKDAY(TODAY(),2)

See here for WEEKDAY function details: https://www.techonthenet.com/excel/formulas/weekday.php

 

[PCRIDE]

These worked! So simple! Thanks again for the super quick help. I haven’t used Weekday before.