Forum Discussion

Antonio3333's avatar
Antonio3333
Copper Contributor
Feb 01, 2024
Solved

Diference between 2 collums with Year-Weeknumber

Hi Team,  How can calculate the diference between this 2 collums? Thank you    
excel
Formulas and Functions
office 365
  • m_tarler's avatar
    m_tarler
    Feb 01, 2024
    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)