Prev: join imported Excel 2007 files
Next: help creating a time function
From: Monique on 21 Jan 2010 13:02
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.
From: T. Valko on 21 Jan 2010 13:09
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(a)discussions.microsoft.com> wrote in message
news:2E4C8E96-319A-4872-8927-4B7179BA0030(a)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.


From: Yanick on 21 Jan 2010 13:33
On Jan 21, 1:02 pm, Monique <Moni...(a)discussions.microsoft.com> wrote:
> 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.

Assuming you date is in A1

=Date(Year(A1),Month(A1),1)
 | 
Pages: 1
Prev: join imported Excel 2007 files
Next: help creating a time function