Excel Guides

Putting a Different Date in a Header in Excel

If you want to put a different date in a header in Excel, there are a few different ways that you can do this. One way is to use the TEXT function. The TEXT function can be used to convert a date into text in a specific format. For example, if you have a date in cell A1 and you want to convert it into the text "January 1, 2014", you would use the following formula:

=TEXT(A1,"mmmm d, yyyy")

Another way to put a different date in a header in Excel is to use the DATEVALUE function. The DATEVALUE function can be used to convert text into a date. For example, if you have the text "January 1, 2014" in cell A1 and you want to convert it into a date, you would use the following formula:

=DATEVALUE(A1)

You can also use the DATE function to create a date from individual year, month, and day values. For example, if you have the year in cell A1, the month in cell B1, and the day in cell C1, you can use the following formula to create a date:

=DATE(A1,B1,C1)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.