Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Most Current Date
Hello,
I have a worksheet that I keep track of quotes submitted. I have columns: Customer, Submit Date, Award Date, Price Quoted, and Won/Lost. I have another worksheet that is linked that keeps a cumulative total of the quotes that are lost. On that worksheet I have Last Award Date, Company, # of Quotes, and Total Value. My question, is it possible to have the most current award date for each company? I have it setup so companies that win multiple times are listed on one row with total # awards won, total value of awards. I would like to automatically insert the most recent award date each time an award is issued to that company. Any help is appreciated. Thanks. Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
enter a current date in a cell? | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Calculating current age from 2 date cells | Excel Worksheet Functions | |||
How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions |