Courses / Power Query (Get & Transform)
30. Date.From and Date.AddDays
Converting values to date type and basic date arithmetic using Date.From and Date.AddDays, etc.
1 min read Chapter 30 of 43
Power Query M
Date.From and Date.AddDays
Functions to convert values into date type and perform simple date arithmetic safely.
"I need the date part of mixed values and to add or subtract days reliably — like Excel but in Power Query."
Date.From converts numbers, text, datetimes, or nulls into a date value (or null); Date.AddDays adds or subtracts whole days from a date value.
"I need the date part of mixed values and to add or subtract days reliably — like Excel but in Power Query."
Date.From converts numbers, text, datetimes, or nulls into a date value (or null); Date.AddDays adds or subtracts whole days from a date value.