Hi,

Im creating an excel sheet to track my accounts and I wonder if someone
could give me some advice on a couple of if statements I cant figure out?

1. I want a the first column in the sheet to look at the date in second
column and thendisplay which quarter the work was completed in, so the
statement would run something like this: €œif the date in the adjacent cell is
between January and march, display €˜Q1€�.

2. I need to track keep a running track of profits. Subtracting current
expenditure from profit is easy, but I also have to factor in a weekly
national insurance payment. I want to tell excel to check the weekly rate,
then tell it to check the current date, and each week add that weeks payment
to total insurance payments to date. This total can then be subtracted from
the total profit along with other expenditure.

If anyone can help me with either formula Id be very grateful.

Thanks

Karl