Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to identify weekend dates
Hello,
I have two columns with dates. Column A = Transaction Date and Column B = Post Date. Is it possible to use a formula to identify those transactions ( A) that occurred on a weekend? Thank you! Cathy |
#2
|
|||
|
|||
Try this:
=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"Weekend","Wee kday") "Cathy Landry" wrote: Hello, I have two columns with dates. Column A = Transaction Date and Column B = Post Date. Is it possible to use a formula to identify those transactions ( A) that occurred on a weekend? Thank you! Cathy |
#3
|
|||
|
|||
Hi!
One way: =IF(WEEKDAY(A1,2)5,"Weekend","") Will return Weekend if the date in cell A1 is on the weekend, otherwise, returns blank. Biff "Cathy Landry" wrote in message ... Hello, I have two columns with dates. Column A = Transaction Date and Column B = Post Date. Is it possible to use a formula to identify those transactions ( A) that occurred on a weekend? Thank you! Cathy |
#4
|
|||
|
|||
If a date is in A1, then =WEEKDAY(A1,2)) will return 6 for Saturday and 7 for
Sunday. So =IF(WEEKDAY(A1,2)5,"weekend","") -- Gary's Student "Cathy Landry" wrote: Hello, I have two columns with dates. Column A = Transaction Date and Column B = Post Date. Is it possible to use a formula to identify those transactions ( A) that occurred on a weekend? Thank you! Cathy |
#5
|
|||
|
|||
Barb, thank you for the quick response! That worked!!! When you have time,
would you mind looking at my other post from 08/19 (required fields with comments)? Thank you again! "Barb Reinhardt" wrote: Try this: =IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"Weekend","Wee kday") "Cathy Landry" wrote: Hello, I have two columns with dates. Column A = Transaction Date and Column B = Post Date. Is it possible to use a formula to identify those transactions ( A) that occurred on a weekend? Thank you! Cathy |
#6
|
|||
|
|||
Thank you everyone who replied!!!! I now have several different ways to
identify weekend expenditures.....this will really help my audit review! "Biff" wrote: Hi! One way: =IF(WEEKDAY(A1,2)5,"Weekend","") Will return Weekend if the date in cell A1 is on the weekend, otherwise, returns blank. Biff "Cathy Landry" wrote in message ... Hello, I have two columns with dates. Column A = Transaction Date and Column B = Post Date. Is it possible to use a formula to identify those transactions ( A) that occurred on a weekend? Thank you! Cathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Identify Column Number | Excel Discussion (Misc queries) | |||
Identify month in a period and run a formula | Excel Discussion (Misc queries) | |||
IF formula to flag exp dates | Excel Worksheet Functions | |||
Formula including dates | Excel Worksheet Functions | |||
Excel running date formula minus weekend days | Excel Worksheet Functions |