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
|
|||
|
|||
Showing financial years
Hi,
I got this formula off a previous posting, which shows financial year. FinYr: Year(DateAdd("m",-3,[DatePaid])) What I need the formula to do is to return the actual financial years that a payment relates to. For example, if an invoice was paid on 11/02/2003 the formula only returns 2003. What I need the formula to show is 2002/2003, as these are the relating financial years (01/04/02-31/03/2003) and 2003 on its own could be interpreted being paid in 2003/2004 - if you catch my drift. I'm unable to solve it myself so would be glad of some help from the experts. Thanks Tony |
#2
|
|||
|
|||
FinYr: IIf(Month([DatePaid])=3,Year([DatePaid])-1 & "/" &
Year([DatePaid]),Year([DatePaid]) & "/" & Year([DatePaid])+1) Does this do the trick? -Raoul "Tony" wrote: Hi, I got this formula off a previous posting, which shows financial year. FinYr: Year(DateAdd("m",-3,[DatePaid])) What I need the formula to do is to return the actual financial years that a payment relates to. For example, if an invoice was paid on 11/02/2003 the formula only returns 2003. What I need the formula to show is 2002/2003, as these are the relating financial years (01/04/02-31/03/2003) and 2003 on its own could be interpreted being paid in 2003/2004 - if you catch my drift. I'm unable to solve it myself so would be glad of some help from the experts. Thanks Tony |
#3
|
|||
|
|||
Raoul,
Perfect - thanks very much Tony -----Original Message----- FinYr: IIf(Month([DatePaid])=3,Year([DatePaid])-1 & "/" & Year([DatePaid]),Year([DatePaid]) & "/" & Year([DatePaid]) +1) Does this do the trick? -Raoul "Tony" wrote: Hi, I got this formula off a previous posting, which shows financial year. FinYr: Year(DateAdd("m",-3,[DatePaid])) What I need the formula to do is to return the actual financial years that a payment relates to. For example, if an invoice was paid on 11/02/2003 the formula only returns 2003. What I need the formula to show is 2002/2003, as these are the relating financial years (01/04/02-31/03/2003) and 2003 on its own could be interpreted being paid in 2003/2004 - if you catch my drift. I'm unable to solve it myself so would be glad of some help from the experts. Thanks Tony . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FINANCIAL FUNCTIONS | Brent | Worksheet Functions | 13 | September 9th, 2004 12:43 AM |
Handling Leap Years in Calculation | Jim Schlotz | Worksheet Functions | 1 | October 29th, 2003 11:47 PM |