Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Problem
Hi,
Suppose I have a excel column that contains the dates: Column A ( DD/MM/YY) 09/02/07 10/02/07 etc How do I select the column and read in each dates in each cell to check if the date: (DD) is a friday and that the date is 6th? Thanks. regards, Newbie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Problem
I'm not sure what you're looking for but if A1 has a date then this formula
in another cell will tell you if it is a Friday: =IF(WEEKDAY(A1)=6,"Friday","Not Friday") -- Jim " wrote in message ups.com... | Hi, | | Suppose I have a excel column that contains the dates: | | Column A ( DD/MM/YY) | | 09/02/07 | 10/02/07 | etc | | How do I select the column and read in each dates in each cell to | check if the date: (DD) is a friday and that the date is 6th? | | Thanks. | | regards, | Newbie | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Programming | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) |