Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick #141 part 1: Day Numbers to Dates

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,265
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 28, 2008

See how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date. =DATE(2008,11,1) will put the date 11/1/2008 in a cell.

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more