Day of week and date in same cell, autofill rest of month?
Closed
zinnia
-
Mar 24, 2015 at 04:49 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 25, 2015 at 05:59 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 25, 2015 at 05:59 AM
Related:
- Day of week and date in same cell, autofill rest of month?
- Time of day clock stopped - Guide
- Windows calendar show week number - Guide
- Battery rest code - Guide
- Hay day download pc - Download - Simulation
- Based on the values of cell b77 ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 25, 2015 at 05:59 AM
Mar 25, 2015 at 05:59 AM
type a date in a cell according to regional convention(either m/d/yy or d/m/yy).see control panel-region and language-short date.
Then click format-date
there is one format day, date
take the cursor to the bottom right when cursor turns to black plus sig. click this plus sign and drag the mouse down.
you get something like this
Wednesday, March 25, 2015
Thursday, March 26, 2015
Friday, March 27, 2015
Saturday, March 28, 2015
Then click format-date
there is one format day, date
take the cursor to the bottom right when cursor turns to black plus sig. click this plus sign and drag the mouse down.
you get something like this
Wednesday, March 25, 2015
Thursday, March 26, 2015
Friday, March 27, 2015
Saturday, March 28, 2015