| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Current Month with real date
Hey all,
I'm trying to have a cell always reflect the current month and year. I'm sure it's a simple formula but I need some help. I'm wanting this formula in a cell and then I have a calendar control cell that is linked to to it... ie. A1 (formula cell) and then D15=A1 I've already used =TEXT(EDATE(TODAY(),0),"mmmm") this returns nothing but ###### etc. and =(MONTH(NOW())) this returns Jan 1900 and =YEAR(MONTH(NOW())) this returns Mar 1905 The calendar works fine when I have real date (11/1/2005) in cell A1. Help please, K Last edited by Keyrookie : November 30th 09 at 09:31 PM Reason: more info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight the cell date of current month | Excel Discussion (Misc queries) | |||
| How do I show the current month in a date field? | Excel Discussion (Misc queries) | |||
| Year-to-date based on current month | Excel Discussion (Misc queries) | |||
| Current date formula based on month | Excel Discussion (Misc queries) | |||
| Pulling a date in the current month | Excel Worksheet Functions | |||
Threaded Mode
