| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates
Hi,
I am trying to add 6 months to a date in column A. Dates are formatted as dd/mm/yy (UK). I have tried a few different ideas but the amended date switches to US format. This despite the cells being formatted as UK Dates. My current formula is =SUM(MONTH(A5))+(6) Any ideas please? Mickey Start Date 6 Month Date 01/06/2005 12/01/1900 01/01/2001 07/01/1900 01/02/2001 08/01/1900 01/06/2005 12/01/1900 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
![MBlake[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
