| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
| Iteration inconsistancy | Excel Discussion (Misc queries) | |||
| Problems with date input | Excel Discussion (Misc queries) | |||
| date input | Excel Discussion (Misc queries) | |||
| How do make input date by "month/day" in Excel? | Excel Discussion (Misc queries) | |||
![PhilM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
