LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 150
Default Produce the most recent date

I have a stock sheet in which i keep track of the date that stock was
received, where the stock is stored and the total stock. I enter the date
that the stock was received and the date that it was entered into the storage
place. What i need is for the Total Stock sheet to automatically calculate
the most recent date the stock was received.

Basically i want to use a function to compare two dates and produce the most
recent one, but am not sure which function will do this as the one that i
know only do this for numbers in which the smallest or earliest figure is
obvious...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
most recent date (correction) excelFan Excel Discussion (Misc queries) 6 December 21st 06 06:43 PM
most recent date excelFan Excel Discussion (Misc queries) 1 December 21st 06 02:57 PM
keep rows with most recent date Richard Excel Discussion (Misc queries) 0 December 4th 06 08:21 PM
Looking up the most recent date CatatonicBug Excel Worksheet Functions 3 September 8th 06 08:46 PM
produce a formulate to produce assigned seats for dinner DavidJoss Excel Worksheet Functions 0 October 4th 05 02:29 AM


All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"