| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to fetch the date of first weekend of a month
In Cell $A$1 I insert a certain date.
What formula (or combinations thereof) in another cell would derive the date of FIRST Saturday in the month of the date inserted in $A$1? Thanx again guys! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to fetch the date of first weekend of a month
Look he
http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear item First weekday of month -- Kind regards, Niek Otten Microsoft MVP - Excel "FARAZ QURESHI" wrote in message ... In Cell $A$1 I insert a certain date. What formula (or combinations thereof) in another cell would derive the date of FIRST Saturday in the month of the date inserted in $A$1? Thanx again guys! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to fetch the date of first weekend of a month
Hi,
Try this =A1-DAY(A1)+CHOOSE(WEEKDAY(A1-DAY(A1)),6,5,4,3,2,1,7) Mike "FARAZ QURESHI" wrote: In Cell $A$1 I insert a certain date. What formula (or combinations thereof) in another cell would derive the date of FIRST Saturday in the month of the date inserted in $A$1? Thanx again guys! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to fetch the date of first weekend of a month
=DATE(YEAR(TODAY()),MONTH(A1),1)+MOD(7-WEEKDAY(DATE(YEAR(TODAY()),MONTH(A1),1)),7) "Niek Otten" wrote: Look he http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear item First weekday of month -- Kind regards, Niek Otten Microsoft MVP - Excel "FARAZ QURESHI" wrote in message ... In Cell $A$1 I insert a certain date. What formula (or combinations thereof) in another cell would derive the date of FIRST Saturday in the month of the date inserted in $A$1? Thanx again guys! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formual to determine if date falls on weekend, adjust date to Mond | Excel Discussion (Misc queries) | |||
| If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
| workdays formula ends on weekend date | Excel Worksheet Functions | |||
| Last weekend of month | Excel Worksheet Functions | |||
| Excel running date formula minus weekend days | Excel Worksheet Functions | |||
Linear Mode
