Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 06 February 2019
  0 Replies
  2.6K Visits
0
Votes
Undo
Hi,

I need help in one of excel formula where the formula needs to be changed horizontally when dragged, but this works only vertically, I need this in order to calculate Total Breaks from reference cell for each day.


='6th Feb'!K3 ( COLUMN "B") now when I drag this vertically it changes as ='6th Feb'!K4, ='6th Feb'!K5,='6th Feb'!K6 .which is good now I need this to be the same way for Horizontally along with date change and cell reference to be changed, but its not happening. Please help.

Big Thank you in advance.
There are no replies made for this post yet.