Help please,

I have a column of dates that I want to format if they match another column of dates.

Ex. AF251:AF255 = T249:T275

In other words, if any of the dates in cells AF251:AF255 match the dates in cells T249:T275 I want the format to change. So far all I have is this:

=AND($T$249:$T$259)

but every cell from AF251:AF255 reformats. I want only the cells with matching dates to reformat.

Thanks in advance,

K

I don't understand how:
=TEXT(EDATE(TODAY(),0),"mmmm")
can return ###'s.

Are you sure that this is the formula you used?

This:
=month(now())
will return the number 11 (if you put it in a cell that is formatted as
General).

If you format that cell as a date, then excel will see that 11 as the 11th day
after a base date--and for most people in the wintel world, that base date is
December 31, 1899. So 11 is seen as January 11, 1900.

So format the cell as general and you'll see the 11.

Same kind of thing with
=year(month(now()))

That's the equivalent of:
=year(11) the 11th day of 1900.

=========
If you have a real date in A1, you could just give it a custom format:

MMMM YYYY
(or whatever you want)

with:
=today()
as the formula in A1


Keyrookie wrote:

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

--
Keyrookie

--

Dave Peterson

On Mon, 30 Nov 2009 21:29:09 +0000, Keyrookie
wrote:

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.

It is simple, and depends on how you want to "reflect" the current month and
year.

A1: cell to have current month and year

A1: =today()
format/cells/number Custom: mmm-yyyy
--ron

Thanks for the repsonses,

Sorry, I didn't explain things well. I have a calender and in the Friday column I want the cells to reformat if they match a range of dates located elswhere in the spreadsheet. The application is work hours have to be submitted on Friday every 2 weeks. Because these dates are constantly changing but not the day (Friday), I need a formula that will recognize the dates in the RANGE and then if it matches or equals the date in the Friday COLUMN I need it to reformat.

If there is another way to achieve this result I'm all ears. I may be approaching this problem from the wrong angle.

K