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.
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.