SharePoint Calculated column to Check If today is 14th date

Question

I have date time column called Today.

I'm trying to create calculated column which check today is 14

Value for Today column is 4/13/2017 I m trying to check that is today is 14. means like this (4/14/2017)

score 3 · Accepted Answer · answered Apr 14 '17 at 07:26

Remember that SharePoint is NOT Excel, so Formulas do not update Date calculations

Formula:

=DAY( [DateTime] )

gets you the day number

=IF( DAY( [DateTime] )=14 , "It is the 14th" , "Not the 14th" )

1 Answers1