What do you put in T9?
How's your worksheet is constructed?


"nastech" wrote:

trying to find way to compare a previous days quantity, to today's business
hours, probably as a percentage of a day?... thanks

have sample of formula:

IF(TODAY()DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T9 ,6,2)-(10+1)),"d",

for yymmdd / NOW
2007-04-30 8:41:43 PM