This is most likely a simple problem.
I have a sheet where the user must input a date (dd-mm-yyyy). Based on this date, an adjacent cell displays the name of the
weekday (I do this by copying the value of the original date, and displaying the cell as "dddd".
I would very much like the value of this cell to be the name of the weekday, as I have another cell which checks to see if
the inputted date, is (for example) a tuesday. I do this by using:
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This doesn't work though.
I had hoped that there was a copy/paste option to only copy the visible data of a cell, but no.
Does anyone have
any tips on how to do this? I have searched for something similar, but was unable to find anything.
PS. I included a small example, it's very simplified, maybe it's excessive, but it might help
explaining what's going wrong.