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
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
Try this:
=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"Weekend","Weekday")
"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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
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
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","Weekday")
>
> "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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks