# How do I return a value, based on a date, between dates? (versus week numbers)?

Options
✭✭✭✭✭
edited 12/09/19

I am trying to return a value to a cell, based on a date condition at the top of the column.  For example, if there were 52 columns of the "week dates" in a year.  The parameter for the return value is IF the date condition falls between a start date and finish date.

I have been able to do this when I convert all dates to a week number date (=WEEKNUMBER([Column2]14)

The formula for this is below. It works pretty well, but I dont like having to have the helper columns for the week number conversion.

=IF(AND(\$[start week]\$14 <= [weeknumber]3, \$[Complete week]\$14 >= [weeknumber]3), \$GPweek\$14, "0")

Is there a way I can do this by just using the actual dates? Thanks, Jef

• Employee
Options

Hello,

Happy to help.  Currently, we don’t have a WEEK Function to determine week of the year but this will be considered as a possibility for future development.

Cheers,

Eric

Smartsheet Support

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!