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: 1
Default Return date if in range, else return blank


My apologies in advance if too much information, just wanting to get
anything possible needed out there to save back and forth for the experts! :)


The first thing in the worksheet includes calculating the date of
anniversary for events based up on start date, adding the 25, 85 or 181
months to know when that next level kicks in. Currently, I am using the
following calculation, having to change the mmddyy fields in the first cell
of each row, then copy to the 85 & 180 months columns (I & J). Is there an
easier way?

Row Column B Column H Column I Column J
Column K
1
1/1/2009
2 25 85
181 12/31/2009
3 25-84 mos 85-180 mos 181 mos
4 Hire Date Level 1 Level 2 Level 3
2009
5 11/1/2007 12/1/2009 12/1/2014 12/1/2022

The calculation I'm using in H5 is:
=DATE(2007,11+H$2,1) then just copying it to the right

As such, for each row I have to manually change each mo dy yr - is there an
easier way?


The next challenge is for column K to look at the three columns to the left
(H, I & J) and IF the date falls within that calendar year (currently
manually entered in K1 1/1/2009 & K2 12/31/2009), THEN return that date, else
return blank.

There may be a way to just make it look at the year and IF 2009 (or that
year) then return the value, else blank but I can't seem to find that either.

Thanks so much in advance for any assistance! Let me know if I left out any
needed info.

LisaL

 
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
Return value 1 row above non-blank cell in range Mifty Excel Discussion (Misc queries) 4 May 12th 08 09:51 PM
Vlookup to return blank cell if nothing in range Haz Excel Discussion (Misc queries) 2 April 15th 08 08:22 PM
Sumif to return a blank if sum range is blank [email protected] Excel Worksheet Functions 3 May 25th 06 10:25 AM
find the first blank cell in a range and return me it's position steve alcock Links and Linking in Excel 2 May 13th 05 09:03 AM
if the value of a cell in a range is not blank, then return the v. kvail Excel Worksheet Functions 2 April 8th 05 10:07 PM


All times are GMT +1. The time now is 08:17 PM.

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"