True or False Week Number - Rolling

New Contributor

I have been trying forever today to get a function to work, or find one that does work

I am trying to:

Take the current week number, and if the date is equal to the current week number, have the cell say true or false. 

2 Replies

@Vibrantvictoria93 

Perhaps like this?

Screenshot 2023-02-23 at 07.34.38.png

@Riny_van_Eekelen 

 

Oh my gosh yes. Thank you so so much! That is exactly what I needed!