| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Idenfying WeekDays
My date data comes in like this....
20071202 20071202 20071203 20071203 20071203 20071203 20071203 20071203 20071204 20071204 20071204 20071204 Is there a formula that can identfy weekdays ? Thank You In Advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Idenfying WeekDays
With your sample data in A1:A12
This formula returns TRUE for weekdays, FALSE for weekends: B1: =WEEKDAY(TEXT(A1,"0000-00-00"),2)<6 Alternatively, this formula calcs A1 as a date: B1: =--TEXT(A1,"0000-00-00") Then you can format it to display as a date or weekday. Either way, copy the formula down as far as you need. Is that something you can work with? or do you need something else? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "carl" wrote in message ... My date data comes in like this.... 20071202 20071202 20071203 20071203 20071203 20071203 20071203 20071203 20071204 20071204 20071204 20071204 Is there a formula that can identfy weekdays ? Thank You In Advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Idenfying WeekDays
One way with your data in A1:
=TEXT(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4),"dddd") HTH, Paul -- "carl" wrote in message ... My date data comes in like this.... 20071202 20071202 20071203 20071203 20071203 20071203 20071203 20071203 20071204 20071204 20071204 20071204 Is there a formula that can identfy weekdays ? Thank You In Advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Idenfying WeekDays
hi try this
=weekday(date(left(a2,4),month(mid(a2,5,2),day(rig ht(a2,2)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "carl" escreveu: My date data comes in like this.... 20071202 20071202 20071203 20071203 20071203 20071203 20071203 20071203 20071204 20071204 20071204 20071204 Is there a formula that can identfy weekdays ? Thank You In Advance |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Idenfying WeekDays
I would run the data through DataText to ColumnsNextNextColumn Data
FormatDateYMD Then in an adjacent column enter =WEEKDAY(cellref) and copy down. Gord Dibben MS Excel MVP On Mon, 17 Dec 2007 12:11:08 -0800, carl wrote: My date data comes in like this.... 20071202 20071202 20071203 20071203 20071203 20071203 20071203 20071203 20071204 20071204 20071204 20071204 Is there a formula that can identfy weekdays ? Thank You In Advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekdays only! | Excel Discussion (Misc queries) | |||
| Number of Weekdays | Excel Worksheet Functions | |||
| WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
| Date, Weekdays | Excel Discussion (Misc queries) | |||
| Weekdays | Excel Discussion (Misc queries) | |||
Linear Mode
