Excel date input inconsistancy
 

I have created a spreadsheet for data collection which is utilising
userforms for this purpose. The data is for the last financial year
(06-07) and the date options in the combo box reflect this (using
month only) When selected though the year changes to 07 from 06 (ie
April 06 as selected becomes April 07) How can I rectify this?

Excel date input inconsistancy
 

If financial year is April to March:

To calculate the year :

in say A1:

IF(MONTH<=3,YEAR(TODAY()),YEAR(TODAY())-1)

Where MONTH is your Userform selection.

HTH

"PhilM" wrote:

I have created a spreadsheet for data collection which is utilising
userforms for this purpose. The data is for the last financial year
(06-07) and the date options in the combo box reflect this (using
month only) When selected though the year changes to 07 from 06 (ie
April 06 as selected becomes April 07) How can I rectify this?