How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Neil Armani Your Own Question

Neil Armani
Neil Armani, Consultant
Category: Computer
Satisfied Customers: 49
Experience:  10+ Years Experience as Network Administrator; MCSE; A+
Type Your Computer Question Here...
Neil Armani is online now
A new question is answered every 9 seconds

what does dollar sign mean in this excel formula ...

Customer Question

what does dollar sign mean in this excel formula =DATE(N$3,O11,$P$3)
Submitted: 8 years ago.
Category: Computer
Expert:  Neil Armani replied 8 years ago.

Thank you for choosing Just Answer!

Since we're dealing with a "=DATE" range, I'll stick to that specific idiom.

When dates are processed thru Excel, there are characters used as "identity" holders, but ignored while dates are processed. The information in cell [A1] would be identical (to the DATE feature) as information in cell [$A$1].

If you use this data block example in a blank spreadsheet, when you begin stepping into the error code, you will see the references to [$A$1] while the code references [A1].

Since the date entry format is [Year, Month, Day], this code simply looks in Cells N3,O11 and P3 to collect it's data.

While you can associate $ characters in many excel equations, using them in the DATE routine is simply another way to express one cell in two formats.

If you find this information useful, please consider ACCEPTing my answer.

Thank you for your time.