Prev: Print Preview Different than What I see in the Excel File
Next: Repost - Functions on filtered data
From: Jen_T on 25 Mar 2010 12:21
Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.
From: Gary''s Student on 25 Mar 2010 12:26
In B2:

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

--
Gary''s Student - gsnu201001


"Jen_T" wrote:

> Does anyone know how to have excel look at a cell that has a date that is
> formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
> 01/01/2007 in B2, another words view as date as first day of the month.
From: Ron Rosenfeld on 25 Mar 2010 13:16
On Thu, 25 Mar 2010 09:21:02 -0700, Jen_T <JenT(a)discussions.microsoft.com>
wrote:

>Does anyone know how to have excel look at a cell that has a date that is
>formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
>01/01/2007 in B2, another words view as date as first day of the month.

B2: =A2-DAY(A2)+1
--ron
From: Ashish Mathur on 25 Mar 2010 21:59
Hi,

You may also try this

=EOMONTH(F7,-1)+1

You may need to install the analysis Toolpak for the eomonth function to
work

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Jen_T" <JenT(a)discussions.microsoft.com> wrote in message
news:2F57D42D-879C-4F90-8F49-29A8525D21A5(a)microsoft.com...
> Does anyone know how to have excel look at a cell that has a date that is
> formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
> 01/01/2007 in B2, another words view as date as first day of the month.

 | 
Pages: 1
Prev: Print Preview Different than What I see in the Excel File
Next: Repost - Functions on filtered data