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