Date/Text Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put the current date in two seperate cells.

Example:

Cell B3 - I want the date to look like this: 23rd

Cell D3 - I want the current month to be entered.

I would like to put a formula in both cells so they will automatically
calculate.

Thanks in advance
 
B3:

=DAY(TODAY())&IF(AND(MOD(DAY(TODAY()),100)>=10,MOD(DAY(TODAY()),100)<=14),"th",CHOOSE(MOD(DAY(TODAY()),10)+1,"th","st","nd","rd","th","th","th","th","th","th"))
(this one is from Chip Pearson)

D3:

=TODAY()
and format custom as m, mm, mmm, or mmmm depending on what you require.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Thanks so much!

Niek Otten said:
B3:

=DAY(TODAY())&IF(AND(MOD(DAY(TODAY()),100)>=10,MOD(DAY(TODAY()),100)<=14),"th",CHOOSE(MOD(DAY(TODAY()),10)+1,"th","st","nd","rd","th","th","th","th","th","th"))
(this one is from Chip Pearson)

D3:

=TODAY()
and format custom as m, mm, mmm, or mmmm depending on what you require.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Back
Top