Forum Discussion
Solved
Newbie DAY Function sorry
HI Guys I have a column A with a short date format. I want to add a custom column to it and use the DAY excel function to return the day of each month. What is the syntax I have looked here but whe...
sorry in your case in the "custom column formua:" box:
= each Date.Day([Date])
Hi thorrrr,
We can use DAY function to return the day without any issues.
https://msdn.microsoft.com/en-us/library/ee634390.aspx
Regards,
Charlie Liao
Just get an error if i use your solution
Hi Thorrr,
try the following = each Date.Day([ShortDate])
i think i can see where you made the mistake.
sorry in your case in the "custom column formua:" box:
= each Date.Day([Date])