| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in Excel
Dear All,
I would like to ask you for help with dates I have date for example 31-01-2006 and i trying to add 3 months to each followed date but i have results acordance to preeceding convention Expected date should be 30-04-2006 but my date is 01-05-2006. I would like to change the preceeding or following results depend on other informations Best regards Jarek |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date in Excel
=MIN(DATE(YEAR(A21),MONTH(A21)+{4,3},DAY(A21)*{0,1 }))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "kicek" wrote in message ups.com... Dear All, I would like to ask you for help with dates I have date for example 31-01-2006 and i trying to add 3 months to each followed date but i have results acordance to preeceding convention Expected date should be 30-04-2006 but my date is 01-05-2006. I would like to change the preceeding or following results depend on other informations Best regards Jarek |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date in Excel
If you are always using the end of the month and your date to add to is in
Cell A1: =eomonth({A1},3) You may need to install an Excel Add-in "Analysis Toolpak" for the =eomonth function to be availabe to you. Tools Add-ins -- WebShoe "kicek" wrote: Dear All, I would like to ask you for help with dates I have date for example 31-01-2006 and i trying to add 3 months to each followed date but i have results acordance to preeceding convention Expected date should be 30-04-2006 but my date is 01-05-2006. I would like to change the preceeding or following results depend on other informations Best regards Jarek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Hybrid Mode
