Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi I am try to set it up on a risk register when to review their actions at a
certain date after the actions have been set, initially I was under the impression it was always the month after but have since found out it is more complicated than this: Action Date Review Date November December December or January February February March March or April May May June June or July August August September September or October November I have been messing around with an IF function along the lines of =IF(AND(J17="December",J17="January"),"February",I F(J17="November","December",IF(J17="February","Mar ch",IF(AND(J17="March",J17="April"),"May",IF(J17=" MAY","June",IF(AND(J17="June",J17="July"),"August" ,IF(J17="August","September",IF(AND(J17="September ",J17="October"),"November"))))))) But this isn't working so I was wondering if there was a simpler way of doing it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My discovery on adding months and days to a date! | Excel Worksheet Functions | |||
Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
months between 2 dates!!! | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions |