• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    An =IF Date question

    Pablo Sir No problem and thank you again for all your hellp.
  2. T

    An =IF Date question

    Hi Pablo My name is Theo, I have uploaded a new version of the file with what I managed to put together regarding the average for the month See rows B38 & B39 on both tabs. it is the MD divited by the elapsed days on WS1 & the OMD on WS2 The link...
  3. T

    An =IF Date question

    Hi SirJB7 Here is another thought, can we have let’s say on row C38 on Tab Invoice MD & C38 on Tab Number of Orders, A sum of average for the month? For example if let’s say the total of invoiced value is 500,00.00 for the active days so far & lets say is 19 working days so then the average...
  4. T

    An =IF Date question

    Hi SirJB7 Thank you very match for your assistance, it works great.
  5. T

    An =IF Date question

    Hi kaushik03 Thank you for your kindness and good words, a help and smile goes a long way, May name is Theo, I am very pleased to have found this side, Regards to all members.
  6. T

    An =IF Date question

    Hello SirJB7 Thank you for your input & help, can I please impose on you for little longer, on the second Tab Number of orders, the manual input is on row D5 but the updated file inputs the MD value from the first tab Invoice MD, on the date range, can you please change it to input the Value...
  7. T

    An =IF Date question

    Hello SirJB7 How can I duplicate the function for the Number of Orders Tab.? The manual input is on the D5, Thank you.
  8. T

    An =IF Date question

    Hi SirJB7 Well it works, I am really thankful of your help, I was struggling with this for some time until I stumble to this site, After looking at the work quality & examples on this site I feel very inadequate But I will, when time permits me to get a better understanding of excel. By...
  9. T

    An =IF Date question

    Hi SirJB7 I am not sure what happened with the A3 date it should be =Today(), I have fixed it now. Unless we are on a different time zone? So what I need from all this is to input the value on B1 & and have excel to fill the Value from B1 to the range of rows B12:39 (next to the...
  10. T

    An =IF Date question

    Hello And thank you for your prompt answer to my little problem, Here is a sample file to play with, I need the formula to file the value of the day daily on the month list. https://docs.google.com/open?id=0Bx4FkeIop9stMEVxS2NmSHAyNnc
  11. T

    An =IF Date question

    Hello I will like some help with a report that I am producing I have A field (a3) With =Today (), (named date). I Have a Field (b1) with month to date value named MD updated manually every day. And I have date fields from (a12:a33) the beginning of the month till the end, What I need is a...
Back
Top