formula to identify weekend dates

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
>
>
>

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
>
>
>

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
>
>
>