Is there a way for the date to automatically update whenever the template is opened?
Is there a way for the date to automatically update whenever the template is opened?
When I enter the date 10-Sep in my date column and go top the next cell, the date turn into a five digit number that seems to have nothing to do with a date. What is wrong? I am new to Excel.
IF I CREATE 31 DIFFERENT WORKSHEET AND WANT TO WRITE DATES ON SAME CELL OF EVERY WORKSHET IS SOLUTION IS =TODAY(),BUT IF I WANT DIFFERENT DATES ON EACH WORKSHEET AS SERIAL IE OON SHEET 1 1MAY, SHEET 2 2MAY, SHEET3 3MAY...........
WHAT I NEED TO DO
THANK YOU
i want to convert this text dates into proper date so can performed mat cal on that data
I would like to be able to click on a cell to automatically populate it w/ the current time (or date). How do I do this? Can I use formulas, or are Macros involved (I am not experienced w/ Macros).
Problem:
Entering dates quickly, without having to use delimiters to separate month, day, and year.
Solution 1:
Enter only the \"day\" part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering \"5\", the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, LEFT, MID, and RIGHT functions as shown in the following formula to convert it to a proper date:
=DATEVALUE(LEFT(D2,2)&\"/\"&MID(D2,3,2)&\"/\"&RIGHT(D2,2))
Thus, on entering \"060705\", the above formula will return \"06/07/05\".
Problem:
Entering dates quickly, without having to use delimiters to separate month, day, and year.
Solution 1:
Enter only the \"day\" part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering \"5\", the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, LEFT, MID, and RIGHT functions as shown in the following formula to convert it to a proper date:
=DATEVALUE(LEFT(D2,2)&\"/\"&MID(D2,3,2)&\"/\"&RIGHT(D2,2))
Thus, on entering \"060705\", the above formula will return \"06/07/05\".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks