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)
Or like this:
- 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)- Thank you m_tarler
