1. 

   Arghya
   

   Member
   Joined: Nov '11
   Posts: 1

   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

   Posted 1 year ago #
2. 

   VaraK
   

   Member
   Joined: Jul '10
   Posts: 20

   Try this : =EDATE(A1,-12)

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums