Question on Date Function

  • Thread starter Thread starter C
  • Start date Start date
C

C

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

thank you,
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
 
=DATE(YEAR(TODAY()),month,10)

C said:
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
Click to expand...

See ya!

Daniel M.
 
Back
Top