lynnnow
04-27-2011, 06:26 AM
Hi,
I've got a range of dates and need to find the cell address for the 22nd day of the month.
The date is entered as m/d/yy and formatted to show as mmmm dd, yyyy (Note: The Text function is not used.)
I would like a formula to find the cell address. I can get the cell address with a macro, but don't want to go that route. The cell address is used in four other concatenated formulas that need the cell address.
Also, the dates start with the 23rd of the current month to the 22nd of the next month. So I need the cell address for the 22nd day. Also the date is entered as a heading for a set of 7 columns
Please help.
I've got a range of dates and need to find the cell address for the 22nd day of the month.
The date is entered as m/d/yy and formatted to show as mmmm dd, yyyy (Note: The Text function is not used.)
I would like a formula to find the cell address. I can get the cell address with a macro, but don't want to go that route. The cell address is used in four other concatenated formulas that need the cell address.
Also, the dates start with the 23rd of the current month to the 22nd of the next month. So I need the cell address for the 22nd day. Also the date is entered as a heading for a set of 7 columns
Please help.