End of Month & Beginning of Month return blank

[DDH]

I am trying to have a cell return a blank if no date is in the selected cell
for both Beginning of Month and End of the Month.

I DO NOT have the End of the Month correct. This just returns 1/31/1900
IF(ISERROR(EOMONTH(AE40,0),"",EOMONTH(AE40,0))


I think I have beginning of the month correct To return a blank if no value is in AE41
IF(AE41-DAY(AE41)=0,"",AE41-DAY(AE41)+1)

Thank you for your help.

 

[barry houdini]

When EOMONTH evaluates an empty cell it returns the date 1/31/1900, not a error, so just check for the cell being empty, i.e.

=IF(AE40="","",EOMONTH(AE40,0))

You can get beginning of month with EOMONTH of the previous month +1, so

=IF(AE40="","",EOMONTH(AE40,-1)+1)

 

[DDH]

barry houdini - Thank you for your reply.
They work perfect.
I never thought of using the IF function, I was trying all other ways that were not working.

Thank you so very much for all of your help.