Re: Date in middle of month
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 23 Oct 2006 10:34:47 +0100
Hi
with start date in A1
=A1+14+CHOOSE(WEEKDAY(A1+14,2),0,0,0,0,0,-1,1)
will give the weekday that is closest to the 15th of the month.
--
Regards
Roger Govier
"Sunnyskies" <Sunnyskies@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B7E5E990-2366-401B-ADCA-F08353DEBF3A@xxxxxxxxxxxxxxxx
Sorry Jon does not work, returns the same date as my opening date.
"Jon von der Heyden" wrote:
Hi,
Try: =IF(WEEKDAY(B3,2)=7,B3+1,IF(WEEKDAY(B3,2)=6,B3-1,B3))
Where B3 houses the date.
--
Email: subst1tut3 numb3rs for l3tt3rs...
"Sunnyskies" wrote:
Morning,
Scenario. Have got an opening date say the 2006-10-01 now I want
another
date - closing date the 2006-10-15 but if this closing date falls
into a
weekend then I want the next working day to be shown. The closing
date must
always be around the 15th of the month, but not on weekends (if so
it can
then be on the Monday or preceeding Friday) as mentioned above.
My formula for closing date is currently =EOMONTH(C6,0) with is
showing
2006-10-31, how can I modify this to meet my requirement mentioned
above.
Thanks
.
- Follow-Ups:
- Re: Date in middle of month
- From: Bob Phillips
- Re: Date in middle of month
- Prev by Date: Re: Comparing Data in different formats
- Next by Date: Re: Date in middle of month
- Previous by thread: Re: Comparing Data in different formats
- Next by thread: Re: Date in middle of month
- Index(es):
Relevant Pages
|
