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

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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.
 
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!
 
Back
Top