View Single Post
  #1   Report Post  
Kurtlee
 
Posts: n/a
Default Date formula for footer/header

I'm pretty new to excel. My question is, is there a way to have the date in
the header/footer roll back one day? And if it is a Monday, can it roll back
to Friday? If I use a cell for the date it throws the entire format for a
loop and I end up having an entire row with just 1 thing in it. Any help
would be greatly appreciated.