Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
copy worksheet from previous month and rename to current month | Excel Programming | |||
Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
Current Month | Excel Worksheet Functions |