Convert number to date

richarddec

Board Regular
Joined
Mar 7, 2006
Messages
77
Hello guys and gals!

I have what you probably consider an easy task which I cannot get working on my hands.

In cell G10, I have the the text 20060901 which is supposed to represent September 1, 2006.

Now in cell AA10, I want it to recognize that date format as normal and make sure that number (date) is within the current month. Is this possible?

Thanks in advance!

-Curiously Confused
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
If you're trying to return a TRUE or FALSE, perhaps:

=MID(G10,5,2)+0=MONTH(TODAY())
 

richarddec

Board Regular
Joined
Mar 7, 2006
Messages
77
that works great for month! However if it were 20090901 it still says true. Can it recognize this year and month?
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Try this:

=LEFT(G10,6)=TEXT(TODAY(),"yyyymm")
 

Forum statistics

Threads
1,137,298
Messages
5,680,684
Members
419,924
Latest member
Dhamodharan992

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top