"IF" with date formatting

[u15986]

How do I obtain this desired result: If M5 contains a date, P5 displays 0;
if M5 is empty, P5 displays the number of days passed in the current month
(ex. if M5 is empty and N2 displays 3-May-13 then P5 displays 3)
N2 displays today's date
M5 may or may not display an end date

Thank you,

 

[gsistek]

in P5:
=IF(M5="",DAY(N2),0)

 

[Gerald Higgins]

=if(isblank(M5),day(today()),0)

or

=if(isblank(M5),day(N2),0)

This assumes M5 can only contain a date, or be blank.

If it is possible that M5 may contain something else, such as a text string, or a numeric value that is not a date, then you will need something more complex.