WEEKNUMBER from two columns

Krzysztof

Hi All,

I have two columns where one column will have a DATE and the other one will be blank.

It will never happen that both columns will have a date in them.

Now I want Smartsheet to check which two cells has a Date and show WEEKNUMBER.

 

Paul Newcome

Give this a shot. Just change the column names to whatever you are using...

 

=IF(ISDATE([Date Column 1]@row), WEEKNUMBER([Date Column 1]@row), WEEKNUMBER([Date Column 2]@row))

Krzysztof

This is what I was looking for! 

Thank you very much!

Paul Newcome

Happy to help.