M
mlv
Guys, I need to do something clever with months - although right now I'm not
quite sure what the best approach is.
I'm developing a yearly Company Ledger workbook with 13 sheets, one sheet
per month, plus one 'Setup' sheet as the first sheet.
The idea is that the 'Setup' sheet is filled in with all the company
details, and this information is used to populate the appropriate cells in
the subsequent twelve monthly ledger sheets.
I'd like the monthly ledger sheets to calculate the (UK)VAT due to HM
Revenue & Customs (I don't have a problem with the calculation), but I'd
also like the VAT title cell on the appropriate monthly ledger sheets to
state when the VAT is due to be paid.
One of the cells (assume 'Setup!A1') on the 'Setup' sheet contains the date
that the first VAT Return is due (e.g. 30/06/2007). Subsequent VAT Return
due dates will be 'Setup!A1' + 3 months, 'Setup!A1' + 6 months and
'Setup!A1' + 9 months.
I guess all I need to do is have a default text, something like "Cumulative
VAT due to HMRC this period:' that is entered into the VAT title cell on the
monthly ledger sheets UNLESS the monthly ledger sheet date (assume this is
in cell 'Month 1!B1', 'Month 2!B1', 'Month 3!B1', etc.) has the same date as
cell 'Setup!A1' or as 'Setup!A1' + 3 months, 'Setup!A1' + 6 months or
'Setup!A1' + 9 months, in which case the text in the VAT title cell would
be changed to something like "Total VAT now due to HMRC:".
Unless someone has a better idea.
Please could someone help with the formula?
TIA
quite sure what the best approach is.
I'm developing a yearly Company Ledger workbook with 13 sheets, one sheet
per month, plus one 'Setup' sheet as the first sheet.
The idea is that the 'Setup' sheet is filled in with all the company
details, and this information is used to populate the appropriate cells in
the subsequent twelve monthly ledger sheets.
I'd like the monthly ledger sheets to calculate the (UK)VAT due to HM
Revenue & Customs (I don't have a problem with the calculation), but I'd
also like the VAT title cell on the appropriate monthly ledger sheets to
state when the VAT is due to be paid.
One of the cells (assume 'Setup!A1') on the 'Setup' sheet contains the date
that the first VAT Return is due (e.g. 30/06/2007). Subsequent VAT Return
due dates will be 'Setup!A1' + 3 months, 'Setup!A1' + 6 months and
'Setup!A1' + 9 months.
I guess all I need to do is have a default text, something like "Cumulative
VAT due to HMRC this period:' that is entered into the VAT title cell on the
monthly ledger sheets UNLESS the monthly ledger sheet date (assume this is
in cell 'Month 1!B1', 'Month 2!B1', 'Month 3!B1', etc.) has the same date as
cell 'Setup!A1' or as 'Setup!A1' + 3 months, 'Setup!A1' + 6 months or
'Setup!A1' + 9 months, in which case the text in the VAT title cell would
be changed to something like "Total VAT now due to HMRC:".
Unless someone has a better idea.
Please could someone help with the formula?
TIA