How to copy and input correct month/year in to the Date together from coelom

**Warpnes** · 04-07-2021, 06:06 PM

I attached an excel file about the Month Year issue with the date. I have in one coelom with the beginning of month and year and than afterwards I have the name of the day with number of which date it supposed to be. If anyone would have a permanent solution which I would add to a Power Quarry. So it can automatically merge the Month year with the Day date correctly. Maybe not merger but copy ? So it can be considered as a full date. Thanks

**JohnTopley** · 04-08-2021, 02:31 AM

The Text dates e.g January 2021 have 2 trailing blanks: remove them and you get a correct date 01/01/2021. So creating the rest of your dates is straightforward.

How to copy and input correct month/year in to the Date together from coelom

LinkBack

Thread Tools

Rate This Thread

Display

How to copy and input correct month/year in to the Date together from coelom

Re: How to copy and input correct month/year in to the Date together from coelom

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Automatic date display based on input cells month and year

Date field already exist in different format (month-date-year) & (date-month-year)

[SOLVED] Extract Day, Month and Year from a text box (user input) date value

input the date in a cell will show the month and year base in the database from ms access

Macro or Formula to create Date range by getting input of month and year

Find correct Month and Year from list based on current date and add value to adjacent cell

[SOLVED] Function to Display Input Box, Retrieve Date, and Return Day, Month And Year

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions