Ask Experts Questions for FREE Help !
Ask
    nikeshtnt's Avatar
    nikeshtnt Posts: 52, Reputation: 1
    Junior Member
    		  
    #1

    Feb 26, 2009, 01:52 AM
    Excel Forumla based on dates
    I am processing payment on monthly basis for employees based on per day entitlement. This entitlement changes from 91st day. So every month I get three set of employee

    1. Who have already completed 90 days in previous month
    2. Who would be completing 90 days in next month
    3. Who is completing 90 days during the payment (current) month

    I can make formula for first two but for third I need help.

    I am attaching here the sample data for reference.
    Attached Files
  1. File Type: xls Query.xls (15.0 KB, 131 views)
    2. ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
    		  
    #2

    Feb 26, 2009, 02:12 AM

    It is very obvious that you are in the
    United Kingdom.

    May I be allowed to share with you a better
    presentation of dates that is very much
    better for spreadsheet presentations and
    also auditing of databases.

    Dates are better represented as follows:-

    Year = 9
    Month = 02
    Day = 26

    DATE = 90226

    In this format one can actually sort any
    date in the future.
    KISS's Avatar
    KISS Posts: 12,510, Reputation: 839
    Uber Member
    		  
    #3

    Feb 26, 2009, 03:11 AM


    Is this what your looking for?
    Attached Files
  2. File Type: xls Query1.xls (14.5 KB, 87 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Functional-based and activity based costing [ 3 Answers ]

Criado, My assignment for this week is way above my head, the textbook is not of much help and I need some guidance as I go along. Below is the assignment. I hope you can help me. pmonica Trinity Clinic has identified three activities for daily maternity care: occupancy and feeding, nursing...

Do doctors make mistakes about conception dates and due dates? [ 3 Answers ]

I don't understand, can doctors be wrong about conception dates and due dates?

Painting Cabinets - Oil based or Water based? [ 1 Answers ]

Going to be painting my oak kitchen cabinets white. I heard that oil based paint would be best, but don't want to deal with the extra mess. Is there anything wrong with using a good acrylic enamel?

Excel: Macro to designate a color based on condition [ 1 Answers ]

I have an Excel which has three column. First has name(which might repeat in the coming cells) ,second has condition and the third has color. I want to count the number of color for a particular condition against each name Thanks Bhaskar KP

View more questions Search