Consider Blank Cell in Calculation

[bumfart66]

Date 1	Date 2	Number of Days from Handover
	11/09/2023	45180
11/05/2023	11/09/2023	123
17/05/2023	11/09/2023	117
20/06/2023	11/09/2023	83
07/07/2023	11/09/2023	66
30/01/2023	11/09/2023	224
08/08/2023	11/09/2023	34
07/09/2023	11/09/2023	4

Hello

If i dont have a Date 1 it returns 45180, how can i make this cell display text if there is no date 1 ? for example it would say "no date"

 

[Joe4]

You haven't posted your formula, but you can check to see if the cell with the date is greater than zero, i.e.
=IF(Date1>0,your formula,"no date")