Date formula

[ohforealzzz]

I need a formula that will roll any date back to the first of that month and year.

For example: need 06/24/09 changed to 06/01/09.

Does anyone have any hints?

Thanks!
OhForealzzz

[daddylonglegs]

If you have a date in A1 this formula will give the 1st of that month

=A1-DAY(A1)+1

[NBVC]

=Date(Year(A1),Month(A1),1)

will do it.

[ohforealzzz]

wow. So simple.. I was using IF's and AND's and TEXT's formulas. you guys rock.

Thanks!

[jquonsan]

duh!
=A1-DAY(A1)+1

[david2005wang]

try this formula as per attached example spreadsheet.

Hopefully, your question can be solved.

Regards

David