+ Reply to Thread
Results 1 to 6 of 6

Unknown Formula =[@[Duedate]]

Hybrid View

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Unknown Formula =[@[Duedate]]

    I am trying to interpret a spreadsheet written by someone else (who is not available to explain the logic to me), and I came across this formula:

    =[@[Due Date]]

    I have no idea what this does. There is a column in the table with a heading "Due Date", but there is no named range with that name. The formula returns a date, but how? What is the "@" operator, and the square brackets?

    Thanks in advance for advice.

    OM1950

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    It's a structured table reference.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Unknown Formula =[@[Duedate]]

    Typically, you'd see something like this:

    =TableName[@[Due Date]]

    Where:

    TableName is the name of the table

    If no table name is present:

    =[@[Due Date]]

    That means the formula is in a cell that is within the table itself.

    The outer [ ] mean everything within them belongs to the table named TableName.

    The @ sign means "this row". If the formula is entered in cell X10 then it refers to the cell in the Due Date column on row 10.

    The inner [ ] refer to the column range headed by Due Date.

    If you want to see what the formulas look like in A1 reference style then:

    Select any cell within the table
    Right click>Table>Convert to range

    Select the cell that contains the formula. You might see something like this:

    =Sheet1!$B6

    Now, on the main menu bar click Undo to get the table reformatted back to a table!
    Last edited by Tony Valko; 12-06-2013 at 10:03 PM.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Unknown Formula =[@[Duedate]]

    Thanks very much for this reply - it's obvious that I'm going to have to keep up with the new features in Excel !

    OM1950

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Unknown Formula =[@[Duedate]]

    You're welcome. Thanks for the feedback!

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Unknown Formula =[@[Duedate]]

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

+ 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. Unknown Formula changes
    By izzynh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2012, 09:32 AM
  2. Summing across unknown range in unknown cell!
    By agentred in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-28-2009, 10:10 AM
  3. Duedate not working with cells with formulas
    By unley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2009, 08:51 PM
  4. Workbook call duedate more than one sheet
    By unley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2009, 08:05 PM
  5. [SOLVED] Unknown Formula
    By Lucky_guy2000 in forum Excel General
    Replies: 4
    Last Post: 04-28-2006, 11:25 AM

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