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

OK, I found the solution:

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

This formula will always return the current year and month! Nice.

OK, I found the solution: =DATE(YEAR(TODAY()),MONTH()),1)

This formula will always return the current year and month. Format your cell to your specs. Nice!