# How do you create a formula that calculates weeks out in certain cells based off one cells date?

Hello! I've tried to add a formula to convert an existing column into one with a formula and none are working.

I have a target end date and i want existing cells in a "task section" to calculate the weeks out based off that date

• ✭✭✭✭✭✭

Hi @nelly,

Do you have some screenshots of the columns to assist in demonstrating a formula that would work for you?

If not you could have a formula that deducts the current date from the end date which would give you a value in days and then divide the result by 7. Then you can utilise the round function to either round up or down as you require.

Example to round up to the next full week

=ROUND((([End Date]@row - TODAY()) / 7) + 0.5, 0)

Example to round down to the next full week

=ROUND((([End Date]@row - TODAY()) / 7) - 0.5, 0)

Hope this helps!

John

• Can i share the sheet with you?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!