Posts by Lynda

    Help please


    I am trying to make a basic IT report at work and would like to copy certain screens and put them into my report. Th only problem is that when I press print screen and then paste into word it pastes the whole screen.


    Sometimes I would just like a box that opened or a certain window to appear. Can anyone tell me how to do this.


    Much appreciated


    Lynda

    Hi Thanks for that formula but that doen't seem to work either, and i have tried varying it etc. I will try to explain clearer what I am trying to do.


    Cell A1 has the date that a letter has been recieved, for example today it would have 24/02/03, in cell G1 i would like it to automatically say which date the letter must be replied within which is 3 working days, so it should be 28/02/03. This is okay until i put in a letter that came in on say 27/02/03, it returns a reply date of 02/03/03 which is a Sunday and the office isn't open on a Sunday! How can I get the formula to recognise sat/sun and add on two days if required.


    Does this make sense??


    Thanks


    Lynda

    help please anyone


    I am trying to make a wroksheet that will automatically update the date a letter needs to be answered by i.e. 3 working days. I have the formula correct but can anyone tell me how to get excel to NOT include sat/sun as a working day?? Is this possible


    Thanks


    Lynda
    :puzzled: