locked
first day in month formula RRS feed

  • Question

  • Hello. How do I create a calculated column that has the first day of the referenced month? 
    Sunday, October 2, 2016 6:22 AM

Answers

  • =Date( Year( <column>) , Month( <column> ) , 1)

    http://darren.gosbell.com - please mark correct answers

    • Proposed as answer by Charlie Liao Monday, October 3, 2016 8:17 AM
    • Marked as answer by Charlie Liao Wednesday, October 19, 2016 5:38 AM
    Sunday, October 2, 2016 8:46 AM