Forum Discussion

thorrrr's avatar
thorrrr
Helper I
9 years ago
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...
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    sorry in your case in the "custom column formua:" box:

    = each Date.Day([Date])

thorrrr's avatar
thorrrr
Helper I
9 years ago

Just get an error if i use your solution 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Thorrr, 

try the following = each Date.Day([ShortDate]) 

 

i think i can see where you made the mistake.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    sorry in your case in the "custom column formua:" box:

    = each Date.Day([Date])