I am trying to look for a function that would will display the first of the 
month if the cell I am referencing is a date in that month.

For instance: I have a date that says 12/16/09 I want the function/formula 
to return 12/1/09. 

Is this possible? 

I cant seem to find it anywhere. 

This will return the 1st of the month for the date entered in cell A1:

=A1-DAY(A1)+1

-- 
Biff
Microsoft Excel MVP


"Monique" <Monique@discussions.microsoft.com> wrote in message 
news:2E4C8E96-319A-4872-8927-4B7179BA0030@microsoft.com...
>I am trying to look for a function that would will display the first of the
> month if the cell I am referencing is a date in that month.
>
> For instance: I have a date that says 12/16/09 I want the function/formula
> to return 12/1/09.
>
> Is this possible?
>
> I cant seem to find it anywhere. 

On Jan 21, 1:02=A0pm, Monique <Moni...@discussions.microsoft.com> wrote:
> I am trying to look for a function that would will display the first of t=
he
> month if the cell I am referencing is a date in that month.
>
> For instance: I have a date that says 12/16/09 I want the function/formul=
a
> to return 12/1/09.
>
> Is this possible?
>
> I cant seem to find it anywhere.

Assuming you date is in A1

=3DDate(Year(A1),Month(A1),1)