Posted to microsoft.public.excel.misc

nastech

external usenet poster

Posts: 383

find measure prev. day qty vs bus. hrs today/8..

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regarding Prev. Post.	Sam	Excel Discussion (Misc queries)	1	December 24th 06 07:17 AM
Use Vlookup to find less than today	Bruce	Excel Worksheet Functions	3	April 26th 06 10:05 PM
Spreadsheet won't print changes I made, only what was prev. saved.	mrslar	Excel Worksheet Functions	3	April 11th 06 04:41 PM
Find (Today-21) in a range of dates	JG	Excel Discussion (Misc queries)	4	March 15th 05 03:59 PM
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo.	Fkor	Excel Discussion (Misc queries)	3	March 10th 05 08:29 AM

All times are GMT +1. The time now is 09:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us