There is a simple formula for column F: =IF((B3-TODAY())/7>1,(B3-TODAY())/7,ROUNDUP((B3-TODAY())/7,0))
Then custom format the range with this code
"Payment due in "0" weeks";"Overdue as of today"
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: Mayank Patel <[EMAIL PROTECTED]>
To: excel-macros@googlegroups.com
Sent: Sunday, 2 November, 2008 12:25:30 AM
Subject: $$Excel-Macros$$ Re: Help required for a week wise report
Hi Steve,
Please check the attached file. let me know whether you are satisfied with
the solution given
Macro can also be created for the give format.
Rgds
Mayank
On Sat, Nov 1, 2008 at 10:11 AM, Steven Dsouza <[EMAIL PROTECTED]> wrote:
Hi,
Iam trying to prepare a week wise report from a large volume of payment data.
An example is in the attached spreadsheet. Can someone tell me a easier option
to do this automatically or using excel formulas, as this is being done
presently using filter and sort options, and it consumes a lot of time.
Thanks in advance
Steve
--
Regards
Mayank Patel
9822978041
9422749110
Did you know? You can CHAT without downloading messenger. Go to
http://in.webmessenger.yahoo.com/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
Week wise report.xls
Description: Binary data
