Date calculated column

Question

I have the following list with calculated date columns

enter image description here

I have used the following formula for both the Last Visit and Next visit

=TEXT(Next,"dd mmm, yyyy")

=TEXT(Last,"dd mmm, yyyy")

The top three items do not have anything added in the date field but the calculated column shows 30 Dec 1899.

Can I add something to formula to not show a date in no date has been added to the item?

enter image description here

Danny '365CSI' Engelman · Accepted Answer · 2015-09-19 13:16:20Z

1

=IF(Next="","",TEXT(Next,"dd mmm, yyyy"))

Note: A Blank date is a FALSE value, so this Formula can shortened to:

=IF(Next,TEXT(Next,"dd mmm, yyyy"),"")

20.6k5 gold badges28 silver badges71 bronze badges

answered Oct 25 '14 at 6:16

thomius

2,6988 gold badges29 silver badges47 bronze badges

Thanks, that worked, what formula would I use to show how many days has past since the last Visit column based on todays date? – Matt Saunders Oct 25 '14 at 7:12
1

=TODAY()-Last. You can use Excel (and search engine) to get formulas: msdn.microsoft.com/en-us/library/office/… – thomius Oct 25 '14 at 15:06

add a comment |

Robert Lindgren · Accepted Answer · 2014-10-27 11:43:57Z

0

=IF([Next]="","",TEXT([Next],"dd mmm, yyyy"))

Robert Lindgren

24.1k9 gold badges46 silver badges72 bronze badges

answered Oct 27 '14 at 10:04

chandakmanish04

463 bronze badges

The code is an exact copy of @thomius code? – Robert Lindgren Oct 27 '14 at 11:43

add a comment |

2 Answers 2