Highlight date nearest to TODAY()


Hi

I have dates in a column in this format :

16/01/2010
16/02/2010
16/03/2010
16/04/2010
16/05/2010
16/06/2010


I'm trying to set the conditional formatting so that the nearest date to

today is in bold.

Can someone help with this?


Grateful for any advice.



Best Wishes
0
Colin
3/17/2010 1:40:42 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

5 Replies
1320 Views

Similar Articles

[PageSpeed] 11

Define nearest.

If these were your dates:

15/3/2010
17/3/2010

And today was 16/3/2010

Which is the nearest date?

-- 
Biff
Microsoft Excel MVP


"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message 
news:iw0DNgAaMDoLFwgB@chayes.demon.co.uk...
>
>
> Hi
>
> I have dates in a column in this format :
>
> 16/01/2010
> 16/02/2010
> 16/03/2010
> 16/04/2010
> 16/05/2010
> 16/06/2010
>
>
> I'm trying to set the conditional formatting so that the nearest date to
>
> today is in bold.
>
> Can someone help with this?
>
>
> Grateful for any advice.
>
>
>
> Best Wishes 


0
T
3/17/2010 2:06:27 AM
In article <#vKU0ZXxKHA.2644@TK2MSFTNGP04.phx.gbl>, T. Valko 
<biffinpitt@comcast.net> writes
>Define nearest.
>
>If these were your dates:
>
>15/3/2010
>17/3/2010
>
>And today was 16/3/2010
>
>Which is the nearest date?
>

HI

Thanks for getting back.

All the dates are a month apart in my example. So I guess could Today () 
versus the given date could be set to plus or minus 16.

That would probably do the trick , but I can't think my way through the 
formula to enter into the conditional formatting interface.

Thanks for your help.

0
Colin
3/17/2010 2:19:46 AM
Assuming your data is sort in ascending order

Conditional Formatting:

=$A1=INDEX($A$1:$A$6,MATCH(TODAY(),$A$1:$A$6))



"Colin Hayes" wrote:

> 
> 
> Hi
> 
> I have dates in a column in this format :
> 
> 16/01/2010
> 16/02/2010
> 16/03/2010
> 16/04/2010
> 16/05/2010
> 16/06/2010
> 
> 
> I'm trying to set the conditional formatting so that the nearest date to
> 
> today is in bold.
> 
> Can someone help with this?
> 
> 
> Grateful for any advice.
> 
> 
> 
> Best Wishes
> .
> 
1
Utf
3/17/2010 2:39:02 AM
OK, but you didn't answer my question.

If these were your dates:

15/3/2010
17/3/2010

And today was 16/3/2010

Which is the nearest date?

Both of the dates are an equal difference from the target date. So which is 
the nearest date?

-- 
Biff
Microsoft Excel MVP


"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message 
news:RwCPtZACxDoLFwHj@chayes.demon.co.uk...
> In article <#vKU0ZXxKHA.2644@TK2MSFTNGP04.phx.gbl>, T. Valko 
> <biffinpitt@comcast.net> writes
>>Define nearest.
>>
>>If these were your dates:
>>
>>15/3/2010
>>17/3/2010
>>
>>And today was 16/3/2010
>>
>>Which is the nearest date?
>>
>
> HI
>
> Thanks for getting back.
>
> All the dates are a month apart in my example. So I guess could Today () 
> versus the given date could be set to plus or minus 16.
>
> That would probably do the trick , but I can't think my way through the 
> formula to enter into the conditional formatting interface.
>
> Thanks for your help.
> 


0
T
3/17/2010 3:03:11 AM
This is a multi-part message in MIME format.

------=_NextPart_000_0039_01CAC54A.7B25D850
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

See attached.  Not much for real formulas were needed.  Used Conditional 
formatting in Excel 2007.

A1 has "=Today()"

Then I used Conditional formatting > Highlight Cells Rules > Between...



"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message 
news:iw0DNgAaMDoLFwgB@chayes.demon.co.uk...
>
>
> Hi
>
> I have dates in a column in this format :
>
> 16/01/2010
> 16/02/2010
> 16/03/2010
> 16/04/2010
> 16/05/2010
> 16/06/2010
>
>
> I'm trying to set the conditional formatting so that the nearest date to
>
> today is in bold.
>
> Can someone help with this?
>
>
> Grateful for any advice.
>
>
>
> Best Wishes 

------=_NextPart_000_0039_01CAC54A.7B25D850
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;
	name="Book1.xlsx"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="Book1.xlsx"

UEsDBBQABgAIAAAAIQBrwl5ocwEAAIwFAAATAN8BW0NvbnRlbnRfVHlwZXNdLnhtbCCi2wEooAAC
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAzFRbS8MwFH4X/A8lr9JmmyAibffg5VEHzh8Qm9M1LE1CTja3f+9p6waT
Wpj1wZeWXs53y5ek812toy14VNZkbJpMWASmsFKZVcbelk/xLYswCCOFtgYytgdk8/zyIl3uHWBE
0wYzVoXg7jjHooJaYGIdGPpSWl+LQI9+xZ0o1mIFfDaZ3PDCmgAmxKHBYHn6AKXY6BA97uh1p+Rd
GRbdd/81VBkTzmlViEBC+dbIbySxLUtVgLTFpiboBJ0HIbECCLVOnFfE6F8hBDKGjOfpC5n2SkK0
ED48i5oY+E7zQA6gu04T8jBKRAt21aD8TIhhrwFHU5367UAPzD3xetB4nrWvBUxosl0DrJTDAYbh
7IYz+bB+/W7t+q9TadqQ1EKZg+6+ElCFFt465FS40QKgabQEGTuCBB8UHDPr46YCNt7b2iJvb7PR
Gk6rccQfyqBHx/U/0TF+V/4ij2MnCuvh/CAOe6eZ7mkCb8/S/BMAAP//AwBQSwMEFAAGAAgAAAAh
ALVVMCP1AAAATAIAAAsAzgFfcmVscy8ucmVscyCiygEooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIySz07DMAzG70i8Q+T76m5ICKGlu0xI
uyFUHsAk7h+1jaMkQPf2hAOCSmPb0fbnzz9b3u7maVQfHGIvTsO6KEGxM2J712p4rZ9WD6BiImdp
FMcajhxhV93ebF94pJSbYtf7qLKLixq6lPwjYjQdTxQL8exypZEwUcphaNGTGahl3JTlPYa/HlAt
PNXBaggHeweqPvo8+bK3NE1veC/mfWKXToxAnhM7y3blQ2YLqc/bqJpCy0mDFfOc0xHJ+yJjA54m
2lxP9P+2OHEiS4nQSODzPN+Kc0Dr64Eun2ip+L3OPOKnhOFNZPhhwcUPVF8AAAD//wMAUEsDBBQA
BgAIAAAAIQC7gUTa8AAAAEcDAAAaAAgBeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHMgogQBKKAA
AQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC8ks1qwzAQhO+FvIPYe7y205YSIudSCrmW9AGE
vf4htiS02x+/fYULbgPBvYRcBKNFMx+r2e2/hl59UODOWQ1ZkoIiW7qqs42Gt+PL+gkUi7GV6Z0l
DSMx7IvV3e6VeiPxEbedZxVdLGtoRfwWkcuWBsOJ82TjpHZhMBJlaNCb8mQawjxNHzH89YDizFMd
Kg3hUG1AHUcfk//3dnXdlfTsyveBrFyIwE8XTtwSSTQ1oSHRMF8xTpNNEokBL8PkN4bJl2CyG8Nk
SzAP14RhGfvYs/mPfvRS/P014yW2l37TJ4nTOa8Az+pffAMAAP//AwBQSwMEFAAGAAgAAAAhADVM
ID1eAQAAcAIAAA8AAAB4bC93b3JrYm9vay54bWyMUstOwzAQvCPxD5bvNKnb9KUmlRAgekFIlPZs
4k1j1bEj2yHt37NxlVIEB067452MZ8dZro6VIp9gnTQ6pcNBTAno3Aip9yl93zzdzShxnmvBldGQ
0hM4uspub5atsYcPYw4EBbRLael9vYgil5dQcTcwNWicFMZW3CO0+8jVFrhwJYCvVMTieBJVXGp6
VljY/2iYopA5PJi8qUD7s4gFxT3ad6WsHc2WhVSwPW9EeF2/8Ap9HxUlijv/KKQHkdIxQtPCjwPb
1PeNVN00iSc0yi5LvloioOCN8htcr1fHvNiYscDsothKaN33Rx0kx53UwrQpZWOM9tSjOYI2THZS
+BLHbB4n/dkzyH3pUzqbjuLORnSlHvLDW0IlOiz31mU6xIfq6hr9Y28XEhu7FsNO4RebXbGxv7DZ
n+zRFRv7C3sU3AVxtJRzlWNSXQkmWDJlSWD0P0v2BQAA//8DAFBLAwQUAAYACAAAACEA6aYluIIG
AABTGwAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWzsWU9v2zYUvw/YdyB0b20nthsHdYrYsZutTRvE
boceaZmWWFOiQNJJfRva44ABw7phlwG77TBsK9ACu3SfJluHrQP6FfZISrIYy0vSBhvW1YdEIn98
/9/jI3X12oOIoUMiJOVx26tdrnqIxD4f0zhoe3eG/UsbHpIKx2PMeEza3pxI79rW++9dxZsqJBFB
sD6Wm7jthUolm5WK9GEYy8s8ITHMTbiIsIJXEVTGAh8B3YhV1qrVZiXCNPZQjCMge3syoT5BQ03S
28qI9xi8xkrqAZ+JgSZNnBUGO57WNELOZZcJdIhZ2wM+Y340JA+UhxiWCibaXtX8vMrW1QreTBcx
tWJtYV3f/NJ16YLxdM3wFMEoZ1rr11tXdnL6BsDUMq7X63V7tZyeAWDfB02tLEWa9f5GrZPRLIDs
4zLtbrVRrbv4Av31JZlbnU6n0UplsUQNyD7Wl/Ab1WZ9e83BG5DFN5bw9c52t9t08AZk8c0lfP9K
q1l38QYUMhpPl9Daof1+Sj2HTDjbLYVvAHyjmsIXKIiGPLo0iwmP1apYi/B9LvoA0ECGFY2Rmidk
gn2I4i6ORoJizQBvElyYsUO+XBrSvJD0BU1U2/swwZARC3qvnn//6vlT9Or5k+OHz44f/nT86NHx
wx8tLWfhLo6D4sKX337259cfoz+efvPy8RfleFnE//rDJ7/8/Hk5EDJoIdGLL5/89uzJi68+/f27
xyXwbYFHRfiQRkSiW+QIHfAIdDOGcSUnI3G+FcMQU2cFDoF2CemeCh3grTlmZbgOcY13V0DxKANe
n913ZB2EYqZoCecbYeQA9zhnHS5KDXBD8ypYeDiLg3LmYlbEHWB8WMa7i2PHtb1ZAlUzC0rH9t2Q
OGLuMxwrHJCYKKTn+JSQEu3uUerYdY/6gks+UegeRR1MS00ypCMnkBaLdmkEfpmX6Qyudmyzdxd1
OCvTeoccukhICMxKhB8S5pjxOp4pHJWRHOKIFQ1+E6uwTMjBXPhFXE8q8HRAGEe9MZGybM1tAfoW
nH4DQ70qdfsem0cuUig6LaN5E3NeRO7waTfEUVKGHdA4LGI/kFMIUYz2uSqD73E3Q/Q7+AHHK919
lxLH3acXgjs0cERaBIiemQntSyjUTv2NaPx3xZhRqMY2Bt4V47a3DVtTWUrsnijBq3D/wcK7g2fx
PoFYX9543tXdd3XXe+vr7qpcPmu1XRRYqL26ebB9semSo5VN8oQyNlBzRm5K0ydL2CzGfRjU68wB
keSHpiSEx7S4O7hAYLMGCa4+oiochDiBHrvmaSKBTEkHEiVcwtnODJfS1njo05U9GTb0mcHWA4nV
Hh/b4XU9nB0NcjJmywnM+TNjtK4JnJXZ+pWUKKj9OsxqWqgzc6sZ0Uypc7jlKoMPl1WDwdya0IUg
6F3Ayk04omvWcDbBjIy13e0GnLnFeOEiXSRDPCapj7Teyz6qGSdlsWIuAyB2Snykz3mnWK3AraXJ
vgG3szipyK6+gl3mvTfxUhbBCy/pvD2RjiwuJieL0VHbazXWGh7ycdL2JnCshccoAa9L3fhhFsDd
kK+EDftTk9lk+cKbrUwxNwlqcFNh7b6ksFMHEiHVDpahDQ0zlYYAizUnK/9aA8x6UQrYSH8NKdY3
IBj+NSnAjq5ryWRCfFV0dmFE286+pqWUzxQRg3B8hEZsJg4wuF+HKugzphJuJ0xF0C9wlaatbabc
4pwmXfECy+DsOGZJiNNyq1M0y2QLN3mcy2DeCuKBbqWyG+XOr4pJ+QtSpRjG/zNV9H4C1wXrY+0B
H25yBUY6X9seFyrkUIWSkPp9AY2DqR0QLXAdC9MQVHCfbP4Lcqj/25yzNExaw6lPHdAACQr7kQoF
IftQlkz0nUKslu5dliRLCZmIKogrEyv2iBwSNtQ1sKn3dg+FEOqmmqRlwOBOxp/7nmbQKNBNTjHf
nBqS7702B/7pzscmMyjl1mHT0GT2z0Us2VXterM823uLiuiJRZtVz7ICmBW2glaa9q8pwjm3Wlux
ljRea2TCgReXNYbBvCFK4NIH6T+w/1HhM/txQm+oQ34AtRXBtwZNDMIGovqSbTyQLpB2cASNkx20
waRJWdOmrZO2WrZZX3Cnm/M9YWwt2Vn8fU5j582Zy87JxYs0dmphx9Z2bKWpwbMnUxSGJtlBxjjG
fNUqfnjio/vg6B244p8xJU0wwWclgaH1HJg8gOS3HM3Srb8AAAD//wMAUEsDBBQABgAIAAAAIQA7
bTJLwQAAAEIBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDEueG1sLnJlbHOEj8GKwjAU
RfcD/kN4e5PWhQxDUzciuFXnA2L62gbbl5D3FP17sxxlwOXlcM/lNpv7PKkbZg6RLNS6AoXkYxdo
sPB72i2/QbE46twUCS08kGHTLr6aA05OSonHkFgVC7GFUST9GMN+xNmxjgmpkD7m2UmJeTDJ+Ysb
0Kyqam3yXwe0L0617yzkfVeDOj1SWf7sjn0fPG6jv85I8s+ESTmQYD6iSDnIRe3ygGJB63f2nmt9
DgSmbczL8/YJAAD//wMAUEsDBBQABgAIAAAAIQC4SkstEwEAALcBAAAYAAAAeGwvd29ya3NoZWV0
cy9zaGVldDIueG1sjFDBSsQwEL0L/kOYu01XWZWl7SIsix4EEfWebSdt2CQTkllX/960ZRfBi7d5
eW9e5r1q/eWs+MSYDPkaFkUJAn1LnfF9De9v26t7EImV75QljzV8Y4J1c3lRHSnu04DIIjv4VMPA
HFZSpnZAp1JBAX1mNEWnOMPYyxQiqm5aclZel+WtdMp4mB1W8T8epLVpcUPtwaHn2SSiVZzvT4MJ
CZqqM5kbA4mIuoaHBcimmr79MHhMv2YxptgR7UfiqauhHKXyj3Y7pXiJokOtDpZf6fiIph84V7Y8
u28Uq7weVI/PKvbGJ2FRZ01Z3IGIs36amcL0ugSxI2ZyJzTkgjAXURY3IDQRn8B41rny5gcAAP//
AwBQSwMEFAAGAAgAAAAhALhKSy0TAQAAtwEAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0My54bWyM
UMFKxDAQvQv+Q5i7TVdZlaXtIiyLHgQR9Z5tJ23YJBOSWVf/3rRlF8GLt3l5b17mvWr95az4xJgM
+RoWRQkCfUud8X0N72/bq3sQiZXvlCWPNXxjgnVzeVEdKe7TgMgiO/hUw8AcVlKmdkCnUkEBfWY0
Rac4w9jLFCKqblpyVl6X5a10yniYHVbxPx6ktWlxQ+3BoefZJKJVnO9PgwkJmqozmRsDiYi6hocF
yKaavv0weEy/ZjGm2BHtR+Kpq6EcpfKPdjuleImiQ60Oll/p+IimHzhXtjy7bxSrvB5Uj88q9sYn
YVFnTVncgYizfpqZwvS6BLEjZnInNOSCMBdRFjcgNBGfwHjWufLmBwAA//8DAFBLAwQUAAYACAAA
ACEAyQdJk28CAAAwDgAADQAAAHhsL3N0eWxlcy54bWzsV02L2zAQvRf6H4Tuje00uxsX23sINRTa
pbAp9CrHsiPQh5HkkPTXdyQ5jsMudFtKWYov9mg88zQzemNG2f1RcHSg2jAlc5wsYoyo3KmayTbH
37bluzVGxhJZE64kzfGJGnxfvH2TGXvi9HFPqUUAIU2O99Z2H6LI7PZUELNQHZXwpVFaEAtL3Uam
05TUxjkJHi3j+DYShElcZI2S1qCd6qWFKAZFkZkf6EA4aBIcFdlOcaWRBXgIxGskETRYbAhnlWbO
rCGC8VNQL53CRzTYCSaVdsrIbTm8DDgxzscAli4AUBRZR6ylWpawQIO8PXWwvYRqBBhv9wvrVpNT
sryZOER+wyKrlK6h+tPUg6rIOG0sBKpZu3dvqzp4VspaJUCoGWmVJBzE6OwxCJDOjnL+6E7oe3OF
fWyQ7EUp7Kc6x3DWrghnERIZxIAXFg5/ihawJ7CuWL8Pi47NiH/lnaxeEtXojkjX8dNDLyqqS0+1
gRo+aAhzUourSow5IUeiHD84Z44vwFXPuGVyjPJSBcCsj5O6plABUAQWO5rKmkozEC52h06Plso6
UNIrApV1W+W4LNNNDK0wIeUTNsG5txvP/sGlLDd3m4/eZUJRR2dPx8iHE2LyiiujZsAaOukGI8gT
+i5e3KVpuk5u1+t1unqfrFa+faIr52d28I0UMiK9VecDCA32TC5/e///P8Ohwq+KV3NML+u/uU5z
nZ7+of78fz7zaebTzCc3vcJg9Q/nqNfVd27CgznUkgpuYW7QH4dbmOpr2pCe2+34MccX+QutWS/S
0eorOyjrIXJ8kT+7W0cShtLLVa/4CQAA//8DAFBLAwQUAAYACAAAACEAdUSEdTMDAAAYCwAAGAAA
AHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbIyWXU/bMBSG7yftP1gWd9OaOGn5qNqgagjBxaQJ9nFt
Eqe1SOLMdin8+x2frMiDY2kXoORNH9txnrTv6vK579iTsk6bYc3FLOdMDbVp9LBd8x/frz+fc+a8
HBrZmUGt+Yty/LL6+GF1MPbR7ZTyDEYY3JrvvB+XWebqneqlm5lRDXClNbaXHk7tNnOjVbJBqO+y
Is9Ps17qgU8jLO3/jGHaVtfqytT7Xg1+GsSqTnpYv9vp0fFq1Wi4Fm6IWdWu+UYsN2XJs2qFU//U
6uCiY+blw73qVO1VAzvAWbizB2MewwdvIcphSIcfCEPK2usn9UV13ZrfCNgu9xtnCccwRfY6R3x8
nO8ad+ObZY1q5b7zd+Zwo/R252HiRcBr08Fn4T/rdXgenPXyeVqVbvwOjsTsTOQX5dmCs3rvvOl/
/b2As088ruFKelmtrDkw2FgYyI0yPCaxFHA/dQg3IQ3XqtVTNc+LRbnKnmDZNfwB9wqXJBzSCC7P
aXhOwiGN4Qsahpsklh3SCJ7nNHxKwiGNYUHDZyQc0hguaDi8M+93O6QxnNjtCxIOaQzP6ZlRyPdT
YxzjiwSe8OSNKPPTBF6Qaxchjmc/S+C0aOKNafOEaYJWDeN49oRr8AJSTw3jCF8kbBO0bhjHeMI3
QQuHcYwnjBO0chjHeMI5QUuHcYwnrCvC1+B76zCO8YR1BW0dxjGesK6grcM4xhPWFbR1GMd4wrqC
tg7jGE9YV9DWYRzhpwnrCto6jGM8YV1BW4dxjCesK2jrMI7xhHUFbR3GMZ6wrqStwzjGE9aVtHUY
x3jCupK2DuMYT1gHhYR6ZTCO8bfWTf1i+m2vzdDoUHxkNxULD63t2Ec2JbYe+Klv7/adYv5lhPpW
Q2+5dZw1z+1UbdhotbHav4RJGZQ2K72BbvCg/EGpAapBaHD7TlYnmxPxGfbyeP7PhU/xhWyaMjQJ
aoXVapRb9VXarR4c61QL7SefgYl2akJ47M2IKbweD8ZDzTme7aBCKlhgPoMdbI3xxxNoT2Hce+X3
I4NbgnqIrXDNR2O9ldrzUHS9rmV3NWoYAWZcaih49rYR2J5eO231BwAA//8DAFBLAwQUAAYACAAA
ACEAM29vDOcBAABwCAAAJwAAAHhsL3ByaW50ZXJTZXR0aW5ncy9wcmludGVyU2V0dGluZ3MxLmJp
buxVOy8EURT+7hjPEK+GbqIiIVmsjXaJhESQbLOFZrOGrPXKWOzPUAiVUPgBfoBCVH6EQqESiU4U
std3ZvbujLVCIZHgTM7znjP3njPn3JmFiyLWkYGHPByMIoEYnyHEy5KDFH085Ei3UQ3Kfjy7wUFj
+wksBYX7ls0mkCukLYs0kKujvldX3EZ2qoZZt7ie8fLOaCIWG4qTOCnXy7nvk6gO/CV6UP2gNiLf
tQJPzaEutpLW2iI3vpK61FNsgnXEeqIB349EfGqBMUe5kc07a8X9hM3kzYb9EkgeBqVuvkwiPAr9
c/NzUwNAG1og87XC6VrztSnOmossdlDgPO1SFp8ZbGCJchEOJv1JXPLtcepiSxBz9BHfYc5mYB3G
GKUsZ1fsSc6r8AlahZ+WP9qVAgT3iQIFtPUlvVxmjbHRvaa5r5wzz50ERnwakt+W0+PZ0cVn98M4
ayZ+JZ22HrqB617gsos17AEOWZp+4mC5rlKpBWJ3J0mkobSmXoGsL8ntKA9gkz5bT/ZW021Hxelf
YAVSm8uFvYznLpY/0sxGftUt/K3ShH1SK2+bRtNH4frHMQrH2iZqXdIvb7pS/tU2cVClrbRcihWI
rkjnh2BWJOJcjlIBhQb2dQPPZr35cwSz9AoAAP//AwBQSwMEFAAGAAgAAAAhAPZrWAJFAQAAawIA
ABEACAFkb2NQcm9wcy9jb3JlLnhtbCCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AIySUU/DIBSF3038Dw3vLXQ1myNtl+iyJ5eYWKPxjcDdRlZoA8xu/17abrU6H3yEc+7HOTeki6Mq
g08wVlY6Q3FEUACaV0LqbYZei1V4jwLrmBasrDRk6AQWLfLbm5TXlFcGnk1Vg3ESbOBJ2lJeZ2jn
XE0xtnwHitnIO7QXN5VRzPmj2eKa8T3bAp4QMsUKHBPMMdwCw3ogojNS8AFZH0zZAQTHUIIC7SyO
oxh/ex0YZf8c6JSRU0l3qn2nc9wxW/BeHNxHKwdj0zRRk3QxfP4Yv6+fXrqqodTtrjigPBWccgPM
VSZfgtbSBsWB78GkeKS0WyyZdWu/8I0E8XD6bb42eHJXpMeDCHw02he5KG/J47JYoXxCYhKSJIxn
BUloMqdk/tG+/2O+jdpfqHOKfxPvZpRMR8QLIE/x1ffIvwAAAP//AwBQSwMEFAAGAAgAAAAhAFnx
ECifAQAAVgMAABAACAFkb2NQcm9wcy9hcHAueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAnJNNb9swDIbvA/YfDN0bOekwDIGsYkg29LBhAZK2Z02mY6GyZIisl+zXj7bhxtnH
ZT6RfOkXj0hJ3Z0an3WQ0MVQiOUiFxkEG0sXjoV4OHy++SAyJBNK42OAQpwBxZ1++0btUmwhkQPM
2CJgIWqidi0l2hoagwuWAytVTI0hTtNRxqpyFrbRvjQQSK7y/L2EE0EoobxpXw3F6Lju6H9Ny2h7
Pnw8nFsG1upj23pnDfEp9VdnU8RYUfbpZMErORcV0+3BviRHZ50rOU/V3hoPGzbWlfEISl4K6h5M
P7SdcQm16mjdgaWYMnQ/eWwrkX03CD1OITqTnAnEWH3bmAyxb5GSforpGWsAQiW5YSwO4bx3Hrt3
+nZo4OC6sTcYQVi4Rjw48oDfqp1J9Bfi2znxwDDyjjj7nm8553slHaTVv6WRdH6qYVDM9xvRJjat
CWe9hRAc/jAJMhfsQslJUF9ceMaH9hC3hmDayXVR7Wv+seQ1TvqloO55Hcn3JpvahCOUU8+fQn+D
HsdnoperRc7fcHGmmpKXB6F/AQAA//8DAFBLAQItABQABgAIAAAAIQBrwl5ocwEAAIwFAAATAAAA
AAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhALVVMCP1AAAA
TAIAAAsAAAAAAAAAAAAAAAAAgwMAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhALuBRNrwAAAA
RwMAABoAAAAAAAAAAAAAAAAAbwYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi0AFAAG
AAgAAAAhADVMID1eAQAAcAIAAA8AAAAAAAAAAAAAAAAAnwgAAHhsL3dvcmtib29rLnhtbFBLAQIt
ABQABgAIAAAAIQDppiW4ggYAAFMbAAATAAAAAAAAAAAAAAAAACoKAAB4bC90aGVtZS90aGVtZTEu
eG1sUEsBAi0AFAAGAAgAAAAhADttMkvBAAAAQgEAACMAAAAAAAAAAAAAAAAA3RAAAHhsL3dvcmtz
aGVldHMvX3JlbHMvc2hlZXQxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhALhKSy0TAQAAtwEAABgA
AAAAAAAAAAAAAAAA3xEAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLAQItABQABgAIAAAAIQC4
SkstEwEAALcBAAAYAAAAAAAAAAAAAAAAACgTAAB4bC93b3Jrc2hlZXRzL3NoZWV0My54bWxQSwEC
LQAUAAYACAAAACEAyQdJk28CAAAwDgAADQAAAAAAAAAAAAAAAABxFAAAeGwvc3R5bGVzLnhtbFBL
AQItABQABgAIAAAAIQB1RIR1MwMAABgLAAAYAAAAAAAAAAAAAAAAAAsXAAB4bC93b3Jrc2hlZXRz
L3NoZWV0MS54bWxQSwECLQAUAAYACAAAACEAM29vDOcBAABwCAAAJwAAAAAAAAAAAAAAAAB0GgAA
eGwvcHJpbnRlclNldHRpbmdzL3ByaW50ZXJTZXR0aW5nczEuYmluUEsBAi0AFAAGAAgAAAAhAPZr
WAJFAQAAawIAABEAAAAAAAAAAAAAAAAAoBwAAGRvY1Byb3BzL2NvcmUueG1sUEsBAi0AFAAGAAgA
AAAhAFnxECifAQAAVgMAABAAAAAAAAAAAAAAAAAAHB8AAGRvY1Byb3BzL2FwcC54bWxQSwUGAAAA
AA0ADQBwAwAA8SEAAAAA

------=_NextPart_000_0039_01CAC54A.7B25D850--

0
Dennis
3/17/2010 3:51:41 AM
Reply:

Similar Artilces:

How to increment a list of dates
I have an Excel spreadsheet with a column of successive dates and I want to devise a macro to increment the month by one, at the end of each month so that I can use the sheet again. Is there as easy way to "one-button" this? why not just use a month number in cell e1 (or another and use) =DATE(2004,$E$1,1) -- Don Guillett SalesAid Software donaldb@281.com "Bill" <bill2@mindspring.com> wrote in message news:40qie0hgb2vi0sfltq2acpfrh96it5aapo@4ax.com... > I have an Excel spreadsheet with a column of successive dates and I > want to devise a macro to increment t...

Compare and Highlight Rows
I have an excel file with two worksheets. is there a way to programatically compare the two worksheets to find matches and highlight those matches on each worksheet. They both have the same columns. I want to compare the InspectionID column. The Inspection ID column may have duplicates in both of the worksheets. I have never done anything in excel above the beginner level. However, I am a very skilled VBA programmer (programmed in ACCESS for over 10 years). Thank you You may find it easier to use Conditional formatting instead: For instance, with Sheet1 column A selected, and cel...

add a hire date to the end of year (12/31/05) and get Total years
I need to determine how many years employees have been here. I know the start date (example 6/02/98) At the end of this year (12/31/2005) this person has been here 7 1/2 years. What is the formula to have excel figure this, and display it in number form 7 1/2 or 7.5. Hi there, Depending on how accurate you need this to be you could use the formul =(DATEDIF(A1,B1,"d")/365), where A1 is the employee's start date and B is the year end date. This is only an approximation in the sense tha a year isn't 365 days long but for the sake of this exercise it seem reasonable. H...

Dates
I have a specific need to show 'month and year' and 'day, month and year' in the same column. Because of multiple user input, I would like to make this as simple as possible. If they enter 1/05, I want to see January, 2005 and if the enter 1/10/05, I want to see January 10, 2005. From what I can see, there is no way to format the entire column and acheive the stated goal. One must choose one format and customize/reformat individual cells, which defeats the purpose. Any magic out there? Maybe do this......... Format column A as TEXT Go ahead and enter 1/10, 1/10/05, ...

Date/Time field calculation
Hello, i am trying to make a sum calculation on a field that keeps duration of time. How can i do this? I get errors or zero as result. Thanks On Jun 21, 10:02 am, Stathis <s_paraske...@hotmail.com> wrote: > Hello, > i am trying to make a sum calculation on a field that keeps duration of > time. How can i do this? I get errors or zero as result. > Thanks You need to do the calculation at a level at least 1 level below what you want the answer to be in. Example msgbox DateDiff("h", #6/20/2007 1:00:00 AM#, #6/20/2007 1:30:00 PM#) will give an ans...

highlighting #2
I was told that although that there is no official highlight button for publisher like there is for word but there are ways to get around it. I am using the 2003 version of publisher. does anyone know the trick. Make a small box and fill it with whatever color you want. Place it behind your text and then group it with your text. -- JoAnn Paules MVP Microsoft [Publisher] "justin" <anonymous@discussions.microsoft.com> wrote in message news:17aa701c4496a$65af12f0$a501280a@phx.gbl... > I was told that although that there is no official > highlight button for publish...

copy date in a cell if within a date range
Column M is a listing of percentages Column A is various dates, anywhere from Jan 1, 1998 to the present. I need to copy the contents of let's say M3 into cell T3 is the date in cell A3 is any date in the year 2010. If the date is in another year, leave cell T3 blank Thanks "carrerapaolo" wrote: > Column M is a listing of percentages > > Column A is various dates, anywhere from Jan 1, 1998 to the present. > > I need to copy the contents of let's say M3 into cell T3 is the date in cell > A3 is any date in the year 2010. If the ...

How do I convert a Julian date into a regular date?
I have a long list of Julian dates that are formatted as follows: 3300 1296 0346 The first number is the year, i.e. 2003, 2001, 2000. The next three numbers are the numeric equivalent of where that date falls in the year, i.e. 300=Oct 27, 296=Oct 23, and 346=Dec 12. Excel talks about how to convert to a Julian date, but I have not found how to go from a Julian date to a regular date that I am used to seeing. Many thanks, Jessica Nelson That is not real Julian dates, for your problem you can go to http://www.cpearson.com/excel/jdates.htm real Julian dates is the number of days that ha...

Date Function 03-26-10
If a cell has text and numeric (date) is there a way to pull the date out easily ? E.g. Product dropped off on 11/01/2009 by Michelle Smith I would like to see 11/01/2009 Thank you Try this... =LOOKUP(1E100,--MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))))) Format as Date -- Biff Microsoft Excel MVP "Jen_T" <JenT@discussions.microsoft.com> wrote in message news:24E6D3D1-892D-4A59-8BD4-BFA191F63ED4@microsoft.com... > If a cell has text and numeric (date) is there a way to pull the d...

How do I add on 15 days to a specified date
Column D of my spreadsheet has the dates that I begin various tasks I would like Column E to automatically fix a date 15 days later to be my Target Completion Date Goal. Then I would like Column F to tell me how many days left until the Target Date in Column E The dates in Columns D & E would not change; but the Days Left in Column F would change each day. Please tell me what formulas I should put into Columns E & F Many thanks in advance. ILanger, with date in D2, in E2 put =D2+15 in F2 put =E2-TODAY() and format as general -- Paul B Always backup your data before trying somethi...

Help organizing date
I have a list on a worksheet to organize purchases by the buyer where each the first column designates whether the purchase is a book...b or music...m or video...v. I want to make a master sheet where all the buyer's information is sorted by the catagories listed above. So if Sam bought 1 book 1 video and 1 music (on one worksheet) and Paul bought 2 books 5 videos and 2 musics(on another worksheet), how do I show on a master sheet the date resorted to show all the books music etc in separtate catagories . I want to not just count the books etc, but have the information that follows i...

Setting traffic lights based on todays date against target dates
Hi I have a spreadsheet I use for calculating target dates for issue of student results. At the top I have a cell containing todays date I1 One column contains the first date of the result issue process ie cell number D6 Next column contains the target date for result issue - cell E6 which is calculated by formula (20 workdays after the date in D6) I need to set up a traffic light system in conditional formatting which highlights the target date in E6, firstly amber when today(I1) is 9 workdays after the date in D6, and then a second condition turning to red when today (I1) is 12 workd...

date value
hi all, can anyone tell me which formula shows the value of a date? Mosaddeq is this u r trying say ? =3DDATEVALUE("29-NOV-08") On Nov 29, 11:17=A0pm, "Mosaddeq Aziz" <mosaddeq.a...@gmail.com> wrote: > hi all, > > can anyone tell me which formula shows the value of a date? > > Mosaddeq =today() will always update to show today's date. Mosaddeq Aziz wrote: > > hi all, > > can anyone tell me which formula shows the value of a date? > > Mosaddeq -- Dave Peterson Hi, It's not clear what you are asking! But to...

get number of monday, tuesday,... between 2 dates
Hi, how can I get number of monday, tuesday,... between 2 dates? Thanks, Racsus (Racsus@discussions.microsoft.com) writes: > Hi, how can I get number of monday, tuesday,... between 2 dates? DECLARE @offset int, @day varchar(10) SELECT @day = 'Tuesday' SELECT @offset = CASE @day WHEN 'Monday' THEN 1 WHEN 'Tuesday' THEN 2 WHEN 'Mittwoch' THEN 3 WHEN 'Thursday' THEN 4 WHEN 'Friday' THEN 5 ...

highlight
Hi - just switched to Outlook 2003 from OE. I can't work out how to set up a rule where the message is a different color for a certain sender as I did in O! - can anyone tell me? TIA You can set flags on messages from certain senders. You can set the color of the font used in the list view using Conditional Formatting: View menu > Arrange by > Current View > Customize Current View > Automatic Formatting "Daskarzine" <Daskarzine@doesnotexist.com> wrote in message news:3fab5eb8@duster.adelaide.on.net... > Hi - just switched to Outlook 2003 from OE. I can&...

how to get several payment dates
Hi all! i can't think of how to do this, mabey someone can help me. i have a tbl employees (not our employees but employees from a company thet we sold to) i have the $ amount sold and the # of payments they have to do (credit) this payments vary in that some are every 7 days others every 14, 15 or 30 days, so say an employee bought $100 in Feb-02-2007 and has a credit of 8 weekly payments: EmpID = 1 EmpAmount = $100 EmpCredit = 8 EmpDays = 7 EmpDate = 02/02/2007 now i need to calculate very date we expect payment from them: EmpID EmpNextPay1 EmpNextPay2 EmpNextPay3 EmpNextPa...

Last Contact Date 07-27-07
Hi Everyone, I hope someone can assist me. I would like to create a field on the Contact Entity called “Last Contact Date” (this was a cool field that my previous CRM application had). I have no problem creating the field, but I am looking for the best way to populate the field. Any suggestions would be greatly appreciated. Regards, A.Akin Hi, Where do you get the last contact date data from? populated with Last Modified Date? The easiest way is to do an SQL update. I have done that many times to a datetime field and it's not going to break anything. Just remember this is at you...

Date format 04-20-10
Text in Column E is a date mddyyyy I need to calculate the age but the text format of this date is throwing off the number. Any suggestions 8241938 4121939 8071965 2251950 2101940 12201964 1241980 5311961 3281982 3021967 9171961 10211977 -- Excel isnt just a program its a metaphor for life. Sometimes it is easy and boring.. sometimes it is a little challenging and great.. then there are days it will drive you absolutely INSANE. To calculate the age with data as such ...try =DATEDIF(DATE(RIGHT(TEXT(A1,"00000000"),4), LEFT(TEXT(A1,"00000000&qu...

Outlook Today Calendar button
Hi, I have a situation where a user is downloading emails to a local folder but reads his Calendar from the server mailbox instead. I have modified the outlook.htm file which is embedded in outwvw.dll as shown below to allow the Outlook Today page to reflect the calendar from server mailbox. -------------------------------------------------------------------------------------- <param NAME="Module" VALUE="Calendar"> <param NAME="Path" VALUE="\\Mailbox - XXX\Calendar"> </object> -----------------------------------------------------------...

Dates in a report
I am a database that is tracking customers and their contract amounts. In a report I want to be able to basically take the date today Date() and then take the date they were customers and multiply by how many years it's been times their annual contract amount. I hope this isn't as confusing as it sounds basically i want to do something like this: todays date 12/19/2007-12/19/2005=2 years as customer * $300 (annual contract amount)=$600 I would want to put this in a report and I know how to use the control source. Could someone please assist me in how I would do this. Thank y...

can't highlight cell
When I click on a cell, the contents of the cell are not highlighted. Instead the cell's row and column are highlighted. I can't work with the cell or it's formula itself. Help! Tools>Options, Edit tab, check Edit directly in cell -- Kind Regards, Niek Otten Microsoft MVP - Excel "MM" <MM@discussions.microsoft.com> wrote in message news:3883756F-29AC-482D-8205-F61892E8523D@microsoft.com... > When I click on a cell, the contents of the cell are not highlighted. > Instead the cell's row and column are highlighted. I can't work with the &...

Text highlighting in a TreeList?
Using a TreeList in a dialog, is it possible to add some text highlighting to some of the lines, like changing the color, or making it bold? (There's no indication I can find in my Newcomer book that this is possible, but it's a 9 year old book.) Yes. Owner-draw/Custom-draw tree controls did not exist when I wrote that chapter of the book. Now you would handle the NM_CUSTOMDRAW notification and handle them otherwise like most owner-draw controls. joe On Wed, 21 Nov 2007 15:58:00 -0800, David Deley <deleyd@gte.net> wrote: >Using a TreeList in a dialog, is it possib...

highlights
Hi all Can you help me and tell me if this is at all possible using conditional formatting or a formula I4 is to equal to b4 times c4. If d4 is not the same as i4 then d4 needs to highlight in red. However if d4 is a negative number then d4 should remain normal, not highlighted. Thank You Shorty, =AND(D4>=0, D4<>I4) -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Shorty" <Mysteryjim@sbcglobal.net> wrote in message news:i6I2e.8230$zl.6378@newssvr13.news.prodigy.com... > Hi all > > Can ...

highlight color using keyboard(shortcut)
Could you please tell me how to use keyboard (short cut) to highligh color for any cell or row in excell without moving a mouse to color ta in tool bar menue. Thank you for your help Vicki ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Fairly long key sequence to do it through the menu, rather impractical... my suggestion is to record a marco and assign it a keyboard shortcut. Nikos Y.(nyannaco at in dot gr) >-----Original Message----- > >Could you please ...

displaying multiple dates in a table
any help/advice is much appreciated.... let me explain... i have this table w/c have multiple date/time fields... corresponding to birthdays of people. a single record of a person contains his birthday, his spouse's name & birthday, and also his sons/daughters names & birthdays... now i have already done a query in w/c i can get all persons birthday to display per month (month parameter)... i have done a query just like the one i made above, and it will display the spouses & sons/daughters birthday corresponding to the month i typed in. but the query also displaye...