Posts by eddie57

  • Month

    Re: Month


    How would I get the formula to put a zero in from of the single digit months?


    For example: How can i get "1" to be displayed as "01"


    Thanks
    Eddie

  • Month

    I have a form that I constantly use. It has a section that I enter the current month in the following format: january is 01, february is 02 and so on. I can i get it to do this automatically? I also have a second section on this form that also has this format but is 2 working days ahead of the current date. How would I get it to add 2 working days to the first question?


    thanks
    Eddie

  • Sum Formula

    I am working on a spreadsheet where I want to sum a range plus a second range. The formula I am using is =E9:G9+J9:AO9, I tried it with parenthesis around the E9 and G9, and around J9 and AO9. I do not get a total just the message "#value". Can anyone tell me what am I doing wrong?


    Thanks
    Eddie

  • dates

    Re: dates


    I tried it and got this in the field where i want the current date plus two days: #NAME?. Any idea what is wrong?


    Thanks


    Eddie

  • dates

    How do I add to a date in a field that is a link from another field?



    For example: if my first field has today's date of say January 1, 2005 and i have a link to another page and want this date to always be 2 days later (January 3, 2005), exluding weekends.


    Thanks in advance,
    Eddie