Help

This Week formula for a due date

Topic Labels: Formulas
Solved
Jump to Solution
892 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ahmed_Elagami
7 - App Architect
7 - App Architect

Hi Folks, I need help writing a formula that returns only data for this week related to a release date
I know this formula works IF(WEEKNUM({Release Date})=WEEKNUM(TODAY()),“this week”,“NOT”)
However, it still shows me content released for the next year same as this week. I only want to work on the current year not all years in my view.

Thanks, A lot for your time

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

There are probably a bunch of different ways to do this, but I would probably just do it this way:

IF(
WEEKNUM({Release Date}) & YEAR({Release Date}) =
WEEKNUM(TODAY()) & YEAR(TODAY()),
"this week",'NOT'
)

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

There are probably a bunch of different ways to do this, but I would probably just do it this way:

IF(
WEEKNUM({Release Date}) & YEAR({Release Date}) =
WEEKNUM(TODAY()) & YEAR(TODAY()),
"this week",'NOT'
)

Thanks ALot Scott, I was trying the same thing but was writing the wrong format . This one works like a charm, Appreciate it