Thanks:  0
Likes:  0

# Thread: Convert Calendar month to Financial Month

1. I need a formula that looks at todays date and returns the financial month (not calendar)as an integer eg February should be returned as 8 and can be either +ve or -ve as I will use abs() to convert it. I know it can be done with a lookup table but I was hoping to avoid this. Should be easy but maths was not my strong subject.

2. =MONTH(TODAY())

=MONTH(TODAY())+6

4. On 2002-03-05 17:08, Anonymous wrote:

=MONTH(TODAY())+6
not quite, the financial periods run from July to June therefore the above formulas for December returns 18 where as it should return 6.

5. =IF(MONTH(B1)>6,MONTH(B1)-6,MONTH(B1)+6)

6. Thanks - modified to fit my requirement of current month as follows:
=IF(MONTH(NOW())>6,ABS(MONTH(NOW())-6),MONTH(NOW())+6)

should have known this ops

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•