Calculating weeks in progress by using todays date & start date, letter d appears after number

Susanna Ferry

I am trying to calculate weeks in progress by using todays date & start date, but the letter 'd' appears after every number , eg; 15d

How do I get rid of this letter as it makes the numbers confusing

SteyJ

https://community.smartsheet.com/discussion/114681/calculating-weeks-in-progress-by-using-todays-date-start-date-letter-d-appears-after-number

What is the current formula you're using?

Susanna Ferry

Hi

This is the formula I am using =WEEKNUMBER(TODAY()) - WEEKNUMBER([Start Date]@row)

Genevieve P.

Hi @Susanna Ferry

What column are you adding this formula into? As long as it's in a regular text/number column that's not used for dependencies at all, you should only see a numerical value returned: