Facing issue with EDATE

[dinadvani via OfficeKB.com]

Hi,

I need an urgent help as i am working on a project facing some problems with
excel.

I have defined name range and I am using edate function but it retunrs ?Name

=IF(Namerange,EDATE(This_Month,1),EDATE(This_Month,0))

This_Month is a namerange - Note this formula is copied thru code

this forumla returns ?Name as value but if i edit this formula and then press
a space or enter then it gives me the proper value.

Please assist ASAP

Regards
D

 

[dinadvani via OfficeKB.com]

Someone please assist ASAP. Thanks a lot for your help

 

[dinadvani via OfficeKB.com]

Someone please assist ASAP. Thanks a lot for your helppppppppppppppp

Someone please assist ASAP. Thanks a lot for your help

Hi,

[quoted text clipped - 14 lines]

Regards
D