Formula for average between 2 dates

Hi all,

Probably a very stupid question, but is there a formula that presents the average date between 2 dates. For example, the average date between Monday 4th Septmeber and Wednesday 6th September should be '5th September'


Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Jef Snyders,

    The AVG function will do this for you. If on one row you would use:

    =AVG([1st date]@row, [2nd date]@row)

    If you were wanting to do it without any cell references, then you would use AVG & DATE (using your example):

    =AVG(DATE(2023,9,4), DATE(2023,9,6))

    Hope this helps, but if you've any questions or problems then just post! 😊


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!