Search:

Type: Posts; User: Mark_Miller; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Maud, Happy New Year! Your solution with...

    Maud,

    Happy New Year!

    Your solution with the user defined functions and the named ranges for the holiday groupings is brilliant! Thank you very much. I really appreciate the time you've spent...
  2. Maud, Thank you very much for taking the time...

    Maud,

    Thank you very much for taking the time to look at this again. I will review the new file you've posted and come back to you after Christmas.

    Many thanks,
    Mark
  3. Hi Everyone, I am still struggling with what...

    Hi Everyone,

    I am still struggling with what formula/User Defined Function to use to solve this issue.

    Attached to this message is a clean copy of the spreadsheet if anyone fancies a go.
    ...
  4. Need help with modifying Excel WORKDAY function to calculate date

    Hi Maud,

    Thanks for taking the time to reply. Unfortunately neither the UDF you created for the AOG service nor the formulas you entered in C8 across to F8 are giving the correct result. The...
  5. Need help with modifying Excel WORKDAY function

    I need some help please with modifying a WORKDAY function in Excel. I am using Excel 2007 (UK version). My dates are in the UK format dd/mm/yyyy. Please see attached Excel spreadsheet. The aim of the...
  6. Replies
    12
    Views
    950

    Thank you. ...

    Thank you. http://windowssecrets.com/forums/images/smilies/rolleyes.gif
  7. Replies
    12
    Views
    950

    My colleague has just clarified that some of the...

    My colleague has just clarified that some of the data on the spreadsheet is extracted from his stock system. Crucially the date fields I'm having problems with are actually coming from his system....
  8. Replies
    12
    Views
    950

    Very odd! Is there any way I can extract the date...

    Very odd! Is there any way I can extract the date element out of the formula?
  9. Replies
    12
    Views
    950

    Good question. No I didn't create them. I...

    Good question. No I didn't create them. I received the spreadsheet exactly as you can see it. For the purposes of this forum I've just removed the rest of the columns we have no interest in. It is...
  10. Replies
    12
    Views
    950

    Sorry, you misunderstand. My colleague IS...

    Sorry, you misunderstand. My colleague IS directly typing the date in his end directly as the date.
  11. Replies
    12
    Views
    950

    A colleague of mine in the USA has sent me an...

    A colleague of mine in the USA has sent me an Excel spreadsheet with some dates. He has entered the dates into Excel in the format mm/dd/yyyy. I am based in the UK with my PC regional settings set to...
  12. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Thank you. In addition to the formula Hans provided above that worked off a working day value, I also need a formula (in B17) to work off a calendar day value (B15) as per the attached spreadsheet. ...
  13. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Ok. Understood.
  14. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Hans,

    This works perfectly. Unfortunately I need the Analysis ToolPak running to use the formula =WORKDAY(B3,B4,Z16:Z42)-B3 in cell B5 (Calendar Days Lead Time) on another worksheet. Unless you...
  15. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    No change. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
  16. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Hans, I'm getting '#NAME?' in cell B6.
  17. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    The latest formula you've suggested does do what I expect SOME of the time. Attached is the spreadsheet which will make it easier to explain. The idea is for a user to enter an order date and a...
  18. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Thank you Hans and Steve. I would never have figured that out! I'm still carrying out some testing but first impressions look very promising. I will post back to confirm one way or the other. Thanks...
  19. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Following on from the formula you suggested above, how could this be amended to take into account the following:

    1. If cell B6="Saturday" (as text) and the date in B7 is a Saturday then don't add...
  20. Replies
    22
    Views
    1,377

    Re: Help needed with an IF statement (2002)

    Many thanks. Boy would I struggle without the fantastic support from Woody's Lounge!
  21. Replies
    22
    Views
    1,377

    Help needed with an IF statement (2002)

    Cell B7 is a date. In cell B8 I am trying to write an IF statement that will perform different calculations depending on the day of the week the date in B7 falls on. If the date in B7 is a Saturday,...
  22. Re: Calculating calendar days from working days (Excel 2002)

    Thanks Steve. That works a treat. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
  23. Calculating calendar days from working days (Excel 2002)

    I need a formula that will calculate a calendar day value from a working day value based on a given start date. For example I need to place an order for a part where the supplier has quoted me 4...
  24. Viewing Table names when you hover over Query name (2002)

    Until recently (when the 'Queries' tab is selected), I've been able to hover over a Query name and the associated Table name has displayed. This has now stopped. Do you know how I can turn this...
  25. Replies
    1
    Views
    546

    Field sizes in tables (2002)

    How can I get a table of data (that I have made from a make table query), to have the columns auto fit to the size of the column heading or longest data in that column? Thanks.
Results 1 to 25 of 42
Page 1 of 2 1 2