If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date formula needed
Hi I need a couple of date formulas for invoices recieved, eg. invoice date
is 14/03/2010, payment terms are end of month following. so i need excel to calculate that the due date is in this case 1/05/2010 is the due date. |
#2
|
|||
|
|||
Date formula needed
Try
=DATE(YEAR(A1),MONTH(A1)+2,1) -- Jacob (MVP - Excel) "d7" wrote: Hi I need a couple of date formulas for invoices recieved, eg. invoice date is 14/03/2010, payment terms are end of month following. so i need excel to calculate that the due date is in this case 1/05/2010 is the due date. |
#3
|
|||
|
|||
Date formula needed
Unless d7 really meant what he said in the first half of the post, which was
"end of month following". That would be this: =DATE(YEAR(A1),MONTH(A1)+2,0) Jacob Skaria wrote: Try =DATE(YEAR(A1),MONTH(A1)+2,1) "d7" wrote: Hi I need a couple of date formulas for invoices recieved, eg. invoice date is 14/03/2010, payment terms are end of month following. so i need excel to calculate that the due date is in this case 1/05/2010 is the due date. |
#4
|
|||
|
|||
Date formula needed
And if you are using XL2007 and above, or if you have the Analysis ToolPak
add-in selected for XL2003 or earlier, then you can use this formula... =EOMONTH(A1,1)+1 Remove the "+1" part if you really meant end of the month and not first of the month after the end of the month. -- Rick (MVP - Excel) "d7" wrote in message ... Hi I need a couple of date formulas for invoices recieved, eg. invoice date is 14/03/2010, payment terms are end of month following. so i need excel to calculate that the due date is in this case 1/05/2010 is the due date. |
Thread Tools | |
Display Modes | |
|
|