Adding a column with a fixed value from a cell in an Excel file

[ARamirez1970]

I need to add a column to a PowerQuery that is filled with the same value (in my case, a specific date) contained on a cell in the source Excel file. How do I do that?

 

[SullyWYO]

Add Column > Custom Column

Name the column, and enter = "08/22/2022" (or whatever your preferred date) as the custom formula - the quotes are important, or it will recognize your entry as a math problem. Then, under the Home tab, choose Data Type: Date

 

[SullyWYO]

Edit: I just realized that you want to pull the date from a cell in the source file. There would be different methods, depending on whether the date is just sitting in a cell, or if it is part of a table.