Facing issue with EDATE

  • Thread starter dinadvani via OfficeKB.com
  • Start date
D

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
 
Top