KarenCCarr
Blogger
Share this content
0
2
1421

Has anyone got a spreadsheet formula?

Has anyone got a spreadsheet formula?

I am looking for a formula whereby you can enter your accounting dates and period and it will tell you what is your assesable profits in the opening/closing and change of accounting dates.  Is this too complicated for excel?

Replies

Please login or register to join the discussion.

avatar
By ACDWebb
20th Mar 2012 08:28

Based on what information?
Do you have a table with historical details on it?What are you trying to use the result of the formula for?Is this purely for lookup - in which case a pivot table with a filter  on year end might work or one of the LOOKUP functions?

For me there is insufficient information in your query to be able to make any sort of stab at an answer

Thanks (0)
avatar
By ksalter
20th Mar 2012 08:52

Change of accounting date

This is just one of over 100 tools on the 2020 Tax Tips and Tools.....

www.the2020group.com

2012/13 version of the product is currently under development (awaiting any budget changes this week) and will be released in late April..

Thanks (0)