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

nelly

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

John_Foster

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

nelly

Can i share the sheet with you?