Hello,

I'm currently using this formula to pull out the month, day and year from a
date.

The formula is pulling out the day of the week, but I also would like the
actual day (like today is hte 19th), I would like 19.

Can someone offer some help.

Thanks

Jim,

I'm not quite sure what you want, is it this

=IF(A2="","",TEXT(A2,"dd dddd"))

or this

=IF(A2="","",TEXT(A2,"dd"))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jim" wrote:

Hello,

I'm currently using this formula to pull out the month, day and year from a
date.

The formula is pulling out the day of the week, but I also would like the
actual day (like today is hte 19th), I would like 19.

Can someone offer some help.

Thanks

=IF(A2="","",TEXT(A2,"dddd d")) will give Tuesday 19
--
David Biddulph

"Jim" wrote in message
...
Hello,

I'm currently using this formula to pull out the month, day and year from
a
date.

The formula is pulling out the day of the week, but I also would like the
actual day (like today is hte 19th), I would like 19.

Can someone offer some help.

Thanks

This will get the Date based on the A2 cell value
This will return text number
=VALUE(TEXT(A2,"DD"))
This will return the date as a number
=TEXT(A2,"DD")

This will get the today's Actual Date. But the date will keep on changing
according to the current system date.
This will return text number
=VALUE(TEXT(TODAY(),"DD"))
This will return the date as a number
=TEXT(TODAY(),"DD")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Jim" wrote:

Hello,

I'm currently using this formula to pull out the month, day and year from a
date.

The formula is pulling out the day of the week, but I also would like the
actual day (like today is hte 19th), I would like 19.

Can someone offer some help.

Thanks