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!

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

I'm sure you'll understand the logic

Lee

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?

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

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? ?

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

If so,

IF(G2<=TODAY(),"yes","no")

Now i know i never been a programmer or im lazy or plain stupid...lol Thx lee