Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In cell A129, I have a date value.
In cell B129, I'd like to be able to show the date (in "mmm-yy" format) of the previous June. For example: If A129 shows Aug-08, I'd like B129 to show Jun-08. If A129 shows Apr-09, I'd like B129 to show Jun-08. If A129 shows Jul-09, I'd like B129 to show Jun-09. However, if A129 shows Jun-09, I'd like B129 to show Jun-09. I'm trying to establish the start and end dates for the financial YTD and the month provided. I hope that makes sense. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show date in H2 based on date in I2 minus set number of day | Excel Discussion (Misc queries) | |||
Date subtraction -How to not show negative when 2nd date not entered | New Users to Excel | |||
Show a date based on today | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |