TailorMade IT Solutons Ltd
 
What's New... Welcome Home Page Our Services
TailorMade I.T.Solutions Ltd
Useful Programs
Smart Software
Vision Support
Vision Software
Searches Support
Vision Search
Hotkeys for Vision General Tips & Advice INPS Official Site
INPS Training Services
is accredited with
INPS / IITT
NVUG Official Site DXS HealthCare Info
DXS
Secure Area
LogMeIn Rescue LogMeIn Secure Access Software Support
 

Creating a Day and Week Number from a date value

in Microsoft Excel
To play this video you must have installed the free Adobe Flash Player, please click the link to install it if the video below doesn't run.

The video content presented here requires a more recent version of the Adobe Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here.

Formula used in demonstration

  • =VLOOKUP(A2,patient!A:N,4,FALSE)

  • =TEXT(A2,"dddd")

  • =TEXT(A2,"ddd")

  • =TEXT(A2,"dd")

  • =TEXT(A2,"mmmm")

  • =TEXT(A2,"mmm")

  • =TEXT(A2,"mm")

  • =TEXT(A2,"m")

  • =TEXT(A2,"y")

  • =TEXT(A2,"yyy")

  • =WEEKNUM(A2,1)

  • =WEEKNUM(A2,2)
     
Site search only Google Search