Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to adjust a function to reflect the new year change
Let me reitterate what I need. I have commitment dates for each year. We
enter start date 1/15/07 and want the end date to come up 12/31/2007, first the end date came up 12/31/2008, after the last message it comes up 1/1/2007. "Lisa" wrote: We're getting there, but I need it from start date Jan ?, 2007 and the end date to say Dec ?, 2007, so it will calculate a year later. Now it's giving Dec 2008. "Dave F" wrote: =IF(B37=DATE(2007,01,01),B37,[your formula]) This tests if the date in B37 is Jan 1, 2007. If you need to test for ANY date between Jan 1 2007 AND Jan 31 2007 inclusive, you should change the test to something like =IF(MONTH(B37)=1,B37,[your formula]) Dave -- Brevity is the soul of wit. "Lisa" wrote: I have a formula =DATE(YEAR(B37)+F39,MONTH(B37-1),DAY(B37-1)) This is to calculate yearly contract dates, # of years and start date are entered. this works until I enter a date in Jan 2007, it will give me an end date of 12/2008. I neet to do an IF function to tell excel not to change the date if Jan 07 is used. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change the year in a calendar template to different year | Excel Discussion (Misc queries) | |||
Change Year Date In A Formula Throughout The Spreadsheet | Excel Discussion (Misc queries) | |||
DAYS360 function for 365 day year | Excel Worksheet Functions | |||
Can function in one cell change value or function in another cell? | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |