View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DOR
 
Posts: n/a
Default Move merged cells with conditional formatting?


I hope you were able to download the spreadsheet. Here's another
thought - If you always want your calendar display to start on a
Saturday, the following formula could be substituted for your =TODAY()
formula:

=TODAY()-WEEKDAY(TODAY()+1)+1

This will keep your start day on the Saturday that precedes until today
is Saturday when it will start on today.

Hope this helps

Declan O'R


--
DOR
------------------------------------------------------------------------
DOR's Profile: http://www.excelforum.com/member.php...o&userid=29088
View this thread: http://www.excelforum.com/showthread...hreadid=487999