Hello Excel Gurus,
I need help with my current Excel project. I am a relative BEGINNER using Excel 2003.. with any knowledge of VBA
I have two requests:
1) What FORMULA can I use to have conditional formatting look in Column B for a date (in a column of dates) that is +/- 15 days (or other number in C2) today's date (or other date in C1)?
2) What FORMULA can be used to display that list of names and DOB CHRONOLOGICALLY in column D?
<tbody>
</tbody>
I need help with my current Excel project. I am a relative BEGINNER using Excel 2003.. with any knowledge of VBA
I have two requests:
1) What FORMULA can I use to have conditional formatting look in Column B for a date (in a column of dates) that is +/- 15 days (or other number in C2) today's date (or other date in C1)?
2) What FORMULA can be used to display that list of names and DOB CHRONOLOGICALLY in column D?
Name | DOB | Reference Date = 16 Aug 2015 | List of names and DOB |
John Doe | 05 Aug 1970 | +/- 20 days | Barak Obama - 04 Aug 1961 |
Jane Doe | 06 Nov 1969 | John Doe - 05 Aug 1970 | |
Sally Mae | 22 Aug 1976 | Sally Mae - 22 Aug 1976 | |
Harry Derty | 15 Jan 2002 | Joe Shmoe - 01 Sep 1990 | |
I. Emsilly | 23 Nov 2000 | ||
Yuri Diculus | 19 Mar 2008 | ||
Joe Shmoe | 01 Sep 1990 | ||
Barak Obama | 04 Aug 1961 | ||
Joe Biden | 20 Nov 1942 |
<tbody>
</tbody>