Good morning all,
Attached is a sample of what I am working on.
I have 3 buttons
1) Search for date value of 3/7/2012 and locate the cell
2) Search for date value of 3/8/2012 and locate the cell
3) Search for Wednesday, March 07, 2012 and locate the cell
On the data column I have
1) 3/7/2012
2) Cell 1) + 1
3) 3/7/2012 and I custom format to dddd, mmmm dd, yyyy (Display Wednesday, March 07, 2012)
I can get the first button to work locating cell with 3/7/2012, but not be able to get the 2nd and 3rd.
Please advice on how to search for date value from a formula and special format
Thank you,
NTBSearchDate.xlsm
Bookmarks