Forum Discussion
Solved
Diference between 2 collums with Year-Weeknumber
Hi Team, How can calculate the diference between this 2 collums? Thank you
- I would recommend going back to the original DATE instead of these text outputs. You can do: =QUOTIENT([delivery date]-[requested date],7)
or you could ROUND( ([delivery date]-[requested date]) / 7, 0)
I would recommend going back to the original DATE instead of these text outputs. You can do: =QUOTIENT([delivery date]-[requested date],7)
or you could ROUND( ([delivery date]-[requested date]) / 7, 0)
or you could ROUND( ([delivery date]-[requested date]) / 7, 0)
Thank you m_tarler