Is it possible to get a weeks beginning/ending dates from weeknumber?

davidroy
davidroy
edited 12/09/19 in Smartsheet Basics

I have figured out a different set of formulas to get a beginning/ending date for a specific week and month.  But have been asked if its possible to use the following:

=countif(range, Weeknumber(@cell) = Weeknumber(Today())

to meet a date range criteria (something similar for month).

I've tried the following with no results:

=COUNTIFS({Dugway: 7. Data Processing_Scan Date}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()), {Dugway: 7. Data Processing_Not Surveyable}, false)

I get #INVALID DATA TYPE

Thanks,

David

Comments