LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jerry Kinder
 
Posts: n/a
Default Date Calc. HELP

Hi,
My formula:
IF($H$37<MONTH(3)*YEAR(2005),"",$H$37+3)
IF H37 is less than or grater than March 2005 (not in March) then, display
nothing, elae (if it is in March)display the date+3. I want it to display a
date in March only not in any other month.

H37 has March 26, 2005 in it. I want the formula cell to display March
29th.

If H37 has no date I want the formula cell to display nothing and if the
H37+3 is in April and not in March I want nothing displayed also, diaplay
only if the +3 is a date in March.

What I get with the above is nothing if there is a date in March.

When I change the formula to the following I get the correct date but this
is wrong:

IF($H$37<MONTH(3)*YEAR(2005),$H$37+3,"")

SO what have I done?? What should I do!

Thank you,
JK


 
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
extract date from the most current date Cali00 Excel Discussion (Misc queries) 1 April 13th 05 02:05 PM
Date Math Problem Dkline Excel Worksheet Functions 4 March 4th 05 04:11 PM
Use a calc to figure sum in months using date fields but numeric r susiespassion Excel Worksheet Functions 8 February 6th 05 11:32 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
calc constant date from variable date & return with ability to rn. SusieQ'sQuest Excel Worksheet Functions 1 November 9th 04 08:51 PM


All times are GMT +1. The time now is 05:46 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"