J jessiep New member Local time Yesterday, 23:45 Joined Jul 6, 2006 Messages 7 Jul 17, 2006 #1 I need to change the background color to yellow if the ECDate is 2days or less from today's Date. how do i calculate the two dates? what will be returned? (2 days or 48 hours) Thanks, Jessie
I need to change the background color to yellow if the ECDate is 2days or less from today's Date. how do i calculate the two dates? what will be returned? (2 days or 48 hours) Thanks, Jessie
pbaldy Wino Moderator Staff member Local time Yesterday, 23:45 Joined Aug 30, 2003 Messages 36,272 Jul 17, 2006 #2 The Date() function will get you today's date. The DateAdd() function will let you calculate the other. More info on both in VBA Help.
The Date() function will get you today's date. The DateAdd() function will let you calculate the other. More info on both in VBA Help.
