ON the attached spreadsheet I have cells that conditionally format based on given dates i.e. length of time. I need the dates in the row to change (Mon to Fri) with the given date above that row. E.G. I enter week ending 12/03/17 I then need the Mon to Fri days to read Mon 6th, Tue 7th etc.
Enter your week ENDING date (that's what you asked for...) in G8. In N8, use this, copied across as far as needed:
=$G6+COLUMNS($G:N)-1
in G9, use this, copied across as far as needed:
=$G6-7+COLUMNS($G:G)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you for your swift comprehensive reply - works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks