Date

[Arghya]

Hi,


If I type current date (todays date) in 1 cell, I need last year same date in second cell.


e.g. in Cell A1 value is 25-Nov-2011, I need only Nov-2010 in Cell B1.


Can you please help me out for this query.


Thanx

Arghya

 

[VaraK]

Try this : =EDATE(A1,-12)