VALUE Function in Excel with example

VALUE Function in Excel with example

VALUE

Function converts a text string into Value mainly a Date can be converted into Value which makes a sensible number to perform various operations on a Date. In this article we will see how we can use VALUE function to MINUS two DATES and get final result.

Syntax

=VALUE(Text)

Example

Refer above screen shot where user has plotted a chart and axis margins are translated from DATE to NUMBERS as highlighted. Now it is hard to recognize and fix the Axis boundaries which date it is referring to? The VALUE function helps here to translate the gap and fix the same.

Formula

Output

If you format back to date above numbers you will get same date as column “A” from which the numbers got translated using VALUE function.

Leave a Reply

Your email address will not be published.