Using WEEKNUMBER() Formula

Options
gsmith21
gsmith21
edited 12/09/19 in Formulas and Functions

I'm trying to use the WEEKNUMBER() formula while calling a cell with a date in the format 07/17/19 and I keep getting an INVALID DATA TYPE error and I cannot figure out why.

This is the formula in the cell: 

=WEEKNUMBER([Install Start Date]1)

The [Install Start Date]1 displays 08/08/19 but is gathered from a VLOOKUP into another smartsheet. 

Works perfectly in Excel (with WEEKNUM) but not in Smartsheet.

WEEKNUMBER.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!