first day of the current month
 

I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila

first day of the current month
 

=TODAY()-DAY(TODAY())+1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lila" wrote in message
...
I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to
show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila

first day of the current month
 

One way:

=TODAY()-DAY(TODAY())+1

Another:

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

In article ,
"Lila" wrote:

I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila

first day of the current month
 

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

--
Regards,
Tom Ogilvy


"Lila" wrote in message
...
I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to
show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila

first day of the current month
 

This requires the analysis toolpack addin (Tools Addins Analysis Toolpack).

=EOMONTH(NOW(), -1)+1
--
HTH...

Jim Thomlinson


"Lila" wrote:

I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila

first day of the current month
 

Wonderful! Thanks!

Lila

"Bob Phillips" wrote in message
...
=TODAY()-DAY(TODAY())+1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lila" wrote in message
...
I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to
show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where
a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila