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

[Jim]

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

 

[Mike H]

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.

 

[David Biddulph]

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

 

[Ms-Exl-Learner]

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!