copy cells while click and drag on same row or Column

New Contributor


I'm trying to create a tracking absence and vacation sheet but when it comes to telling the cell to set calendar day on the same row, it literally duplicates it without applying the formula. So my whole row is now Friday only... how can I adjust it so that it calculates the day and date for the rest of the month? thanks to all for your help

4 Replies


With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.


Thank you for your understanding and patience




I know I don't know anything (Socrates)

@Nikolino Thanks a lot for your sugestion! it's very much apreciate.



Perhaps you use absolute references where relative one are required. But it's better to check the formula you use, otherwise we only could make guesses.