Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Dates and IF Functions

Hi, I'm compiling a competency register with a "date of test taken" in one
column, and the next column takes that vale and adds 6 months.

I have mastered the straightforward business of adding the 6 months; but
what i can't prevent is the answer of "29/06/1900" appearing in those cells
where i have yet to enter a value for the "date of test taken".

When i tried an IF function using the date formula as one of the "values if
true" the cells displayed the formula and not the answer.

Thanks

HS


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Dates and IF Functions

What's your formula look like that adds 6 months?

Try it like this:

=IF(A1="","",your_formula_here)

--
Biff
Microsoft Excel MVP


"Happysapper" wrote in message
...
Hi, I'm compiling a competency register with a "date of test taken" in one
column, and the next column takes that vale and adds 6 months.

I have mastered the straightforward business of adding the 6 months; but
what i can't prevent is the answer of "29/06/1900" appearing in those
cells
where i have yet to enter a value for the "date of test taken".

When i tried an IF function using the date formula as one of the "values
if
true" the cells displayed the formula and not the answer.

Thanks

HS




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default Dates and IF Functions

On Mon, 1 Jun 2009 09:49:02 -0700, Happysapper
wrote:

Hi, I'm compiling a competency register with a "date of test taken" in one
column, and the next column takes that vale and adds 6 months.

I have mastered the straightforward business of adding the 6 months; but
what i can't prevent is the answer of "29/06/1900" appearing in those cells
where i have yet to enter a value for the "date of test taken".

When i tried an IF function using the date formula as one of the "values if
true" the cells displayed the formula and not the answer.


Most likely this cell is formatted as text.

A simpler formula might be:

=if(isnumber(cell_ref_with_date_of_test_taken),dat e + 6 months,"")

--ron
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default Dates and IF Functions

Hi,
you can fix the 29/06/1900 from appearing with an if statement

if(A1="","",A1+60)

A1= cell where you enter the date

"Happysapper" wrote:

Hi, I'm compiling a competency register with a "date of test taken" in one
column, and the next column takes that vale and adds 6 months.

I have mastered the straightforward business of adding the 6 months; but
what i can't prevent is the answer of "29/06/1900" appearing in those cells
where i have yet to enter a value for the "date of test taken".

When i tried an IF function using the date formula as one of the "values if
true" the cells displayed the formula and not the answer.

Thanks

HS


Reply
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
If functions and dates spunkyjon Excel Worksheet Functions 4 July 24th 06 12:57 PM
If functions for dates if function for remaining days in month Excel Worksheet Functions 2 October 2nd 05 09:31 PM
Date functions for dates pre-1900 Stephen Larivee Excel Discussion (Misc queries) 2 July 20th 05 08:23 PM
Using Dates in Count functions HWade Excel Worksheet Functions 1 December 6th 04 11:25 PM
worksheet functions with dates Michele Excel Worksheet Functions 3 December 6th 04 07:05 PM


All times are GMT +1. The time now is 11:43 PM.

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

About Us

"It's about Microsoft Excel"