Return 1st Day of Month for a Date

Wanda T

I am trying to avoid complex formulas however have not found a better work around.

 

Objective:  Column/Cell includes a Date, I would like a second column cell to return the Month for that cell

 

Example:

Column: Invoice  | Column:  SchedMos 

 May 15, 2016      |   May 1, 2016  =Mos(Invoice1)

 June 22, 2017    |  June 1, 2017

 

 

I am familiar with the @Month and @Year formulas and can create three new columns (one for Month, one for Year and a third with a formula) to try to get to the outcome I need, however the formula becomes extremely long with IF, then (12 per year).

 

Any ideas?  I might have missed something

 

J. Craig Williams

Wanda,

 

To confirm, you want the first day of the month for any date provided?

 

Assuming column is Invoice and row is 23:

 

=DATE(YEAR(Invoice23),MONTH(Invoice23),1)

 

Cheers,

 

Craig