LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 95
Default Months of review

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My discovery on adding months and days to a date! Epinn Excel Worksheet Functions 8 October 9th 06 10:27 PM
Convert 2 digit month to 4 digit years and months BB Excel Worksheet Functions 2 September 17th 06 09:33 PM
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz naughtyboy Excel Discussion (Misc queries) 3 August 19th 06 05:45 PM
months between 2 dates!!! speary Excel Discussion (Misc queries) 1 August 19th 05 03:22 PM
Why "datedif" function results sometimes negative numbers? Ambrosiy Excel Worksheet Functions 1 July 8th 05 11:29 AM


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"