Changed the formate of a calculated Dimension

[Rosiered]

Hi, 

Please could someone help me with formatting two calculated dimensions. I need to format one as a date and the other as a number with no decimals. 

=IF([Collection2]>Today()+1,'Still Open',[Collection2])

=(Collection2-Delivery2)

Many thanks, 

[Vegar]

Maybe this will help you.

=IF([Collection2]>Today()+1,'Still Open',dayname([Collection2]))

=num(Collection2-Delivery2, '0')

[Rosiered]

Amazing thank you so much that work perfectly 🙂 

[Sharolyn_8312]

Thanks for the information Facetime PC