| 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 |
| 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 | |||
Threaded Mode
