americanpie3
Board Regular
- Joined
- Jul 16, 2003
- Messages
- 187
- Office Version
- 365
Here's my worksheet (sheet 1):
What I would like is to create a lookup of column G (end date) which is 6 weeks away from today's date. Or if it will help to better create the formula 45 days days away from reaching hte end date.
I would create the formula in sheet 2.
Thanx
SoftwareDB.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | SoftwareandLicenseDB | ||||||||
2 | |||||||||
3 | Company | SoftwareSold | Supplier | Licensessold | Datesold | Effectivelicensedate | Enddate | ||
4 | |||||||||
5 | TrafficTech | BackupExec11D | 4 | 22/02/2007 | 22/02/2007 | 21/02/2008 | |||
6 | TrafficTech | BackupExec11D | 1 | 22/02/2007 | 22/02/2007 | 21/02/2007 | |||
7 | Sogelco | FaxTalkPro7.5 | 1 | 10/9/2007 | 10/9/2007 | ||||
8 | Canlyte | Websense | 10/3/2005 | 10/3/2007 | 10/3/2008 | ||||
9 | Canlyte | Internicdomainname | |||||||
Sheet1 |
What I would like is to create a lookup of column G (end date) which is 6 weeks away from today's date. Or if it will help to better create the formula 45 days days away from reaching hte end date.
I would create the formula in sheet 2.
Thanx