+ Reply to Thread
Results 1 to 3 of 3

"Less than or equal to" operator not working with dates

Hybrid View

  1. #1
    Registered User
    Join Date
    05-14-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    21

    "Less than or equal to" operator not working with dates

    I have a weekly cashflow spreadsheet. The columns are the allocated weekly expenses, the column headings are a date = "week ending". I am using the "=IF(AND" comparator to determine if a task (expense) occurs during that particular week. I am using the "<=" equation to test if the task end date is less than or equal to the week ending date. If the task end date is the same as the week ending date, the formula doesn't work. It works for all other dates. Here is my formula:
    = IF(AND(V$19>=$E85,$D85<U$19),DAYS($E85,U$19)*$O85,)

    V$19: Week-ending Date of current week
    U$19: Week-ending Date of previous week
    $D85: Start date of task
    $E85: End date of task
    DAYS($E85,U$19): the number of days in the current week the task is performed.
    $O85: an Expense constant

    Please note, this equation looks only at tasks that started before the week, but finish during the week. I have other equations for tasks that start and finish within the week etc.

  2. #2
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: "Less than or equal to" operator not working with dates

    Hi Plastik Mac,

    Why don't you add the sample data here with the expected result hope you must be having the same ready. Also, include the expected result you looking for.
    Thanks
    Nisha Dhawan


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "

  3. #3
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: "Less than or equal to" operator not working with dates

    Could u plz provide sample workbook
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] "Less than or equal to" operator not working with dates
    By Plastik mac in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2015, 09:14 AM
  2. [SOLVED] Delete Rows if a cell does not equal "Finished" or "Complete"
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-27-2013, 12:40 PM
  3. [SOLVED] IF formula with logical " Less than Or Equal To" NOT WORKING (Data is week number)
    By zeko90 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 02:51 PM
  4. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  5. Replies: 3
    Last Post: 01-19-2006, 02:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1