I have a 12 month rolling financial spreadsheet set up and I have a formula
in a3 that will return a date based on the getinputdate() function in the
"mmm,dd,yyyy" format. I also have that same function in D5-O5 and I have
added another factor to the function to change the year to correspond to
rolling getinputdate and this is formatted as"yyyy". The result for instance
if I ran my report as of April 30th 2007 would display values in each column
rolling back a year my earliest being May 31,2006. My column headings in
D5-O5 would display the correct year (2007 or 2006) for the column and A3
would display April 30, 2007. What I want to do for the Year in my D5-O5
that matches the year in A3 to format with an outline. I have been trying to
do this but have been unsuccessful.
I hope this makes sense and would appreciate any help
Thanks!