Date formula

[pujo]

I'm looking for a way to generate dates from the first of the previous month, to the first of the current month in a column.
This formula will create the dates of the previous month ending on the last day of that month however, I need it to end on the first of the current month.

=EOMONTH(TODAY(),-2)+ROW(INDIRECT("1:"&DAY(EOMONTH(TODAY(),1))))

Can't seem to figure it out.

Thanks!

 

[Fluff]

How about

=EOMONTH(TODAY(),-2)+ROW(INDIRECT("1:"&DAY(EOMONTH(TODAY(),1))+1))

What version of Excel are you using this in?

 

[shaowu459]

=EOMONTH(TODAY(),-2)+ROW(INDIRECT("1:"&1+DAY(EOMONTH(TODAY(),-1))))

 

[pujo]

How about

=EOMONTH(TODAY(),-2)+ROW(INDIRECT("1:"&DAY(EOMONTH(TODAY(),1))+1))

What version of Excel are you using this in?

(O365) As soon as I posted the question, I figured it out.

=EOMONTH(TODAY(),-2)+TIME(7,0,0)+ROW(INDIRECT("1:"&DAY(EOMONTH(TODAY(),2))+1))

I've also added a time stamp to each date.

Thanks!