Prev Previous Post   Next Post Next
  #1   Report Post  
mick2
 
Posts: n/a
Default Finacial Year


Hi!
I have been working on this problem for ages;

Given that a Financial Year, spans two Calendar Years (from 1 July
through to 30 June inclusive), I am tyring to get Excel to
-cyclically-:

Display the number of calendar days remaining in a Financial
Year (beyond *Today()*).
Display the number of calendar days elapsed in a Financial Year (prior
to *Today()*).

Any suggestions?

Regards,
Mick.


--
mick2
------------------------------------------------------------------------
mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=378027

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compare current year to prior year in bar chart? substring Charts and Charting in Excel 4 May 12th 05 07:04 PM
leap year question tiw Excel Discussion (Misc queries) 5 April 20th 05 07:49 PM
How do I sort for the maximum values in each year in excel? The Wrightster Excel Discussion (Misc queries) 3 February 24th 05 05:43 PM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM
Need totals of values that fall within a given year Pierre Excel Worksheet Functions 12 January 5th 05 04:45 PM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"