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
dversa

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
theoriginalinvisible

 

=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
dversa

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
theoriginalinvisible

 

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
dversa

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
theoriginalinvisible

 

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
dversa

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
Thread Forum
Forum for question on Macros in Excel ?
Hello, I am having problems creating a macro in Excel. The keystrokes are not recorded as I expect. Can you advise on the correct section or forum where I should submit my question? Many thanks, Ken
Microsoft Office
Copying filtered table doesn't work as it is expected in Excel 2010
Hi all, I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2). Now everything is ready to start the copying! So I select all the table (Double CTRL+A...
Microsoft Office
Excel always configures & HKCR\.aw access denied
I am trying to debug an annoyance with Excel - it has started including a "Configuring..." and an "...installing.." every time it launches. This is accompanied by an Event Viewer entry: - System - Provider MsiInstaller - EventID 1004 0 Level 3 Task...
Microsoft Office
Microsoft Access/Excel
Can Microsoft Access/Excel update with a barcoding scanner? If yes, which 1 i easier to use?
Microsoft Office
Table Alignment Question
I would appreciate some help on this. When I type a line of simple text and then insert a table directly below it the table does not by default alighn itself to the first letter of the text, it always aligns itself a little before. Should I set Word to show text margins I notice that my...
Microsoft Office
Excel 64 bit question
Hi We looking into upgrading our office to 2010 and we have user who has windows 7 64 bit and is after 64 bit office has use so large Excel spreadsheets for number crunching. Question is can user's using 32bit office 2010 open an excel spreadsheet saved in 64 bit or would use select save as...
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 22:46.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App