Nov 18 2020 08:04 AM
Hi!
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
Nov 18 2020 09:46 AM
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
Nikolino
I know I don't know anything (Socrates)
Nov 19 2020 07:25 AM
@NikolinoDE Thanks a lot for your sugestion! it's very much apreciate.
Nov 19 2020 08:39 AM
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.