I am trying to get a range to return blank if it does not meet my criteria, does anyone know how I can do this.
Here is my problem, Februray has 28 days but 29 days in each leap year, I want the range of cells to return blank if the cell is not the 29th. I am using the =DATE(YEAR(CellRef),MONTH(CellRef),DAY(CellRef) to calculate the days, so for this year it's showing as 01/03/07, i have a numerical column that lists the days ie 1-29 and then my formula to calculate the actual dates, I then have another field that calculates the days ie Monday to Friday which changes for me year on year, but Im having this slight problem with February, I think it's because my brain has gone to sleep...lol All i want to do is mark both the Numerical column and the day column blank if the date does not equal the 29th Feb. If anyone knows how I can accomplish this, I would be most grateful.
2007-05-29
11:36:11
·
4 answers
·
asked by
thornem10
2