• 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. A

    Calculate no.of days present week-wise

    Hi, I have a production tracker which is used to maintain work done daily by employees in the project. There are multiple entries for same date in this excel. The thing is that my Manager wants week-wise attendance of employees in same excel but different sheet. There are four boxes named as...
  2. A

    Urgent..Need Help for date calculation

    Hi, I have a report in which there are no. of dates given. In that report I have to find out any date which is greater than one month in past....and any date which is greater than six months in future..month should be given more importance rather than days. Because for e.g if today is...
  3. A

    Date calculation(Urgent)

    Hi.. Plz help with a formula for conditional formatting.. I have an excel sheet in which there is a column of dates(MM/DD/YYYY).. The formula should be able to highlight any date which is greater than one month in past. The formula[=today()-31] previously u gave did not work to my...
  4. A

    formula to calculate dates in excel

    Hi....I need some more help plz...actually the formula which u gave to calculate dates is not working as per my requirement. I mean to say formula '=today()-31' catches a date which should not be supposed to catch...like eg. if today is 30 July...and in report I see the date as 1 June...It...
  5. A

    formula to calculate dates in excel

    Hi...I want a formula which will calculate dates which will be greater than one month in past...irrespective of any date..and also calculate date which is greater than six months in future irrespective of any date.. could you plz help me with a formula which will work...as I want this formula...
  6. A

    Auto populate items in excel after selecting particular item.

    Hi...I have query in my excel sheet...Its a transport delay tracker which I update as and when I receive email. I have to enter date, emp id, emp name, emp manager name, manager's manager name and place of residence of emp. I want a formula where I will select only the name of emp using drop...
  7. A

    conditional formatting for dates

    Hi, I have a report in which there is a column of dates in mm/dd/yyyy format. Here I have to find out any dates that are greater than one month in past with respect to current month. So I need to do a conditional formatting which will highlight the above criteria in red font. Whatever the...
View older results
Back
Top