Question on Date Function

[C]

Save from doing a validation, is there a formula I can use
to get the 10th day of every month.

thank you,
C

 

[Frank Kabel]

Hi
maybe something like
=DATE(2004,month,10)

 

[C]

Hi Frank,

thanks for the reply. Here's a follow up... how can I
make the formula dynamic and not static? Meaning, how can
I make it so I don't have to change the formula when 2005
comes in?

thanks again!
C

 

[Daniel.M]

=DATE(YEAR(TODAY()),month,10)

Hi Frank,

thanks for the reply. Here's a follow up... how can I
make the formula dynamic and not static? Meaning, how can
I make it so I don't have to change the formula when 2005
comes in?

thanks again!
C

See ya!

Daniel M.

 

[Frank Kabel]

Hi
use something like
=DATE(YEAR(TODAY()),month,10)

 

[Guest]

thank you Frank!

Claudine

-----Original Message-----
Hi
use something like
=DATE(YEAR(TODAY()),month,10)

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Guest]

thanks Daniel!

claudine

-----Original Message-----

=DATE(YEAR(TODAY()),month,10)



See ya!

Daniel M.


.