=TODAY() Formula

[Carl Clements]

Hi,

I am using the =TODAY() formula, which returns 17/03/2009 and I want to grab the day count (17 in this case) by using =left(A1,2) but it returns 39 (from 39889).

Is there a way I can adapt the formula/cell to return 17?

Thanks,
Carl

 

[Willem!]

Hi!

Use: =DAY(TODAY())

 

[VoG]

Try

=DAY(A1)