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

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.