Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: I got a question about excel and/or access table

22 May 2009   #1

Win 7 beta
 
 
I got a question about excel and/or access table

Good day all experts,
I got a question about excel and/or access table preferably 2003 version but if there is a lot of difference between the 2007I would like a solution to:
I try to compare 1 date field and want to fill in a second date field that calculate the different the first date + 1 month and fill in another field with a Yes/No option in that row.
So this is to calculate an invoice date + 1 month to receive the date overdue in another date field.
I use the yes/no to do further calculations to merge and send out letters for those overdue.
Table 1 Table 2 Table 3 Table 4 Table 5
Invoice date: Date overdue: Amount overdue: Letter to send: Send date
09/06/22 ? 100 Yes/No? ?
I hope this all is clear!

My System SpecsSystem Spec
.

22 May 2009   #2

 

=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))

I'm sure you'll understand the logic

Lee
My System SpecsSystem Spec
22 May 2009   #3

Win 7 beta
 
 

Tanks theoriginalinvisible,

It helped very much...just had to replace , by ; and it worked.
Any idea how to flag field to be on/off or yes/no depending on that due date? versus invoice date?
My System SpecsSystem Spec
.


22 May 2009   #4

 

I'm not sure what your conditions are for evaluating the yes/no option, but the formula would be something like:-

=if(your_condition=true,"Yes","No")

If you want to explain further then I'll gladly help. Send me a copy of the workbook if you like

Lee
My System SpecsSystem Spec
22 May 2009   #5

Win 7 beta
 
 

I try to compare 1 date field and want to fill in a second date field that calculate the different the first date + 1 month (THIS IS SOVED BY YOU) and then in a third field trigger an option field with a Yes/No or 1/0 or on/off option in that row depending if the field date overdue is true.
Thanks for helping me out.

Chris

Attached test xls files

Table 1 Table 2 Table 3 Table 4 Table 5
Invoice date: Date overdue: Amount overdue: Letter to send: Send date
09/06/22 ? 100 Yes/No? ?


Attached Files
File Type: zip invoice test files.zip (10.0 KB, 6 views)
My System SpecsSystem Spec
22 May 2009   #6

 

Is it overdue if date due (column G) is smaller than today?

If so,

IF(G2<=TODAY(),"yes","no")
My System SpecsSystem Spec
22 May 2009   #7

Win 7 beta
 
 

Now i know i never been a programmer or im lazy or plain stupid...lol Thx lee
My System SpecsSystem Spec
Reply

 I got a question about excel and/or access table





Thread Tools



Similar help and support threads for2: I got a question about excel and/or access table
Thread Forum
MS Excel Question Microsoft Office
Solved Excel always configures & HKCR\.aw access denied Microsoft Office
Microsoft Excel 2010 - chart formatting question Microsoft Office
Excel 2007: a question about date and time manipulation Software
Microsoft Access/Excel Microsoft Office
Table Alignment Question Microsoft Office
Excel 64 bit question Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:56 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33