Hi,

I want to put specific data into a cell, based on the date in another cell.
i.e. if the date is between two specific dates, populate the other cell with
"A", if between two other dates then "B" etc. I want to fill in a table of
the dates (which are financial periods 1 to 12), so if the date is in period
1, "P 01" is populated to a specific cell. Is this possible?

hope someone can help,
kind regards,

Matt