Dates in cells - is it possible to drag

[m_789]

hey guys ive attatched a spreadsheet which i am doing to monitor agent stats in my team...

what i want to be able to do now is to drag down so the dates automatically go in like they are now? with the weekly total etc

dates must be mon - fri

can any1 help?

is it even possible?

[Paul]

I doubt there is any way to drag anything like that. I've seen some creative use of dragging to increment text and numbers, but not dates interspersed with differing text strings - and over merged cells.

I'd suggest creating a template sheet and put a date in the first cell, then use a formula in the remaining "date" cells that simply add 1 to the previous date cell.

[martindwilson]

with unmerged cells
put first monday in a2 and "daily total" in a6
in a7 put

Please Login or Register  to view this content.

and drag down