Quote:
Originally Posted by Ron Rosenfeld
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
Similar Threads
Threaded Mode
