Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to insert last date in excel 2010

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-02-2010
Member
 
Join Date: Dec 2009
Posts: 83
How to insert last date in excel 2010
  

I have an excel file which has a table for keeping records of ordered items. Hence i try to let itself updated unanimously that's why it requires only a few values to be inputted, But I cannot ask it to read the B3:B11 to get the value of the last non blank cell for displaying a date. I wanted it to display the date on my mane sheet. Please help me to insert the last date in a table

Reply With Quote
  #2  
Old 17-02-2010
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: How to insert last date in excel 2010

To achieve this i will suggest you to use lookup formula and indirect with count so simply use this and i think you will actually get the result what you want i have mentioned the formula below:

=LOOKUP(9^9,B:B) or =LOOKUP(REPT("z"255)B:B)

Edit this formula accordingly to achieve the result what you wanted
__________________
Ram requirement for various OS
Reply With Quote
  #3  
Old 17-02-2010
Member
 
Join Date: Dec 2009
Posts: 83
Re: How to insert last date in excel 2010

Thanks for replying me friends but i would like to tell you that the formula which you suggested =LOOKUP(9^9,B:B) or =LOOKUP(REPT("z"255)B:B) has not helped me at all and hence please try to give me a different solution to get this result also i need this as early as possible. Thanks once again.
Reply With Quote
  #4  
Old 17-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: How to insert last date in excel 2010

I think that the above function should help you in this matter but if the above function is not helping you in this matter then you might have to use the max function of excel for those dates because when you use the maximum value then it will definitely the last date in the table so using this should help you.
Reply With Quote
  #5  
Old 18-02-2010
Member
 
Join Date: Dec 2009
Posts: 83
Re: How to insert last date in excel 2010

First of all i would like to thanks chroma but to my surprise the solution which you suggested has not helped me at all because when i try to use the above formula with the ma function i am not getting the result what i wanted hence i would like to have another solution regarding this matter. So please do the needful.
Reply With Quote
  #6  
Old 18-02-2010
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: How to insert last date in excel 2010

To get this problem solved i tried this on an empty worksheet in which i created a date column in the A1 after that i inserted todays date in A2 cell by Ctrl + ; Then i copied the series of the dates and selected the empty cells in different columns then implemented the MAX function and used the A column as my range the formula will be somewhat like =MAX(A:A).
__________________
Ram requirement for various OS
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to insert last date in excel 2010"
Thread Thread Starter Forum Replies Last Post
Is it possible to have function which can insert date automatically in Excel De-Dg MS Office Support 10 25-02-2012 10:56 AM
MS excel 2010 unable to insert object when linking to a file on a shared volume Khalida Windows Software 6 14-05-2011 11:06 PM
Way to insert a Date Picker in MS Excel cell Chulbul Pandey Windows Software 3 11-12-2010 12:55 AM
Insert date format in SQL via ASP Bansi_WADIA Software Development 4 04-12-2009 10:56 PM
Excel's Time Capture ("Insert a static date or time") Function: Is it possible to have it capture times down to the second? oogoog747 Windows Software 2 10-04-2009 09:36 AM


All times are GMT +5.5. The time now is 11:00 AM.