Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 12th 17, 06:39 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2017
Posts: 4
Default Date of the First Friday every month

i want to create a date table for the first Friday every month
and another one for the second Friday every month
and a third one for the last Friday every month

any help ...

thanks in advance

  #2   Report Post  
Old January 12th 17, 07:54 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,481
Default Date of the First Friday every month

Hi,

Am Wed, 11 Jan 2017 22:39:09 -0800 (PST) schrieb
:

i want to create a date table for the first Friday every month
and another one for the second Friday every month
and a third one for the last Friday every month


have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYcU13VlIJ9tbWImTg


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old January 12th 17, 09:05 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2017
Posts: 4
Default Date of the First Friday every month

thats great ... thank you very much
now if want to use this in my work sheet what i have to do ?
just copy them or i have to do something else ?
  #6   Report Post  
Old January 12th 17, 10:39 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2017
Posts: 4
Default Date of the First Friday every month

i did the second choice and copied the formula and referenced it to data validation list
thank u alot

now i can use it with any day by changing the day reference number ,right?
  #7   Report Post  
Old January 12th 17, 11:22 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,481
Default Date of the First Friday every month

Hi,

Am Thu, 12 Jan 2017 02:39:11 -0800 (PST) schrieb
:

i did the second choice and copied the formula and referenced it to data validation list
thank u alot

now i can use it with any day by changing the day reference number ,right?


=DATUM(C2;1;1)-REST(DATUM(C2;1;1)-2-5;7)+7*1-1
^^

you have to change that number
1 for Monday, 2 for Tuesday, and so on, 5 for Friday


Regards
Claus B.
--
Windows10
Office 2016


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get the date for the 2nd friday of each month? dustin Excel Worksheet Functions 8 November 8th 06 10:46 PM
How can I get a row to display the date of the last friday, and every friday before that? [email protected] Excel Programming 1 April 10th 06 07:42 PM
date of last friday of previous month tkaplan Excel Discussion (Misc queries) 7 November 14th 05 06:05 PM
Friday In Month Winston New Users to Excel 4 October 27th 05 10:00 PM
3rd friday in month [email protected] Excel Worksheet Functions 17 June 11th 05 08:47 PM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017