Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last working day of month
Hello there,
I'm using 2003. I know that you can use the fill series on dates to get every weekday, every 4th of the month, etc. However, I would like to be able to get a list of the dates for the last Friday of each month. Any ideas? Thanks in advance -- Hope this helps |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last working day of month
=DATE(YEAR(A1),MONTH(A1)+1,0)+1-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0)+2)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JudithJubilee" wrote in message ... Hello there, I'm using 2003. I know that you can use the fill series on dates to get every weekday, every 4th of the month, etc. However, I would like to be able to get a list of the dates for the last Friday of each month. Any ideas? Thanks in advance -- Hope this helps |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last working day of month
To list all months, put this in B1
=DATE(YEAR(TODAY()),ROW(A1)+1,0)+1-WEEKDAY(DATE(YEAR(TODAY()),ROW(A1)+1,0)+2) and copy down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JudithJubilee" wrote in message ... Hello there, I'm using 2003. I know that you can use the fill series on dates to get every weekday, every 4th of the month, etc. However, I would like to be able to get a list of the dates for the last Friday of each month. Any ideas? Thanks in advance -- Hope this helps |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last working day of month
Hi,
If you have a list of the a day of each month (any day) in A1:A12, then =EOMONTH(A1,0)-MOD(EOMONTH(A1,0)+1,7) If you just want to enter one day in the first month in cell A1 then use the formula in B1: =EOMONTH(A1,ROW()-1)-MOD(EOMONTH(A1,ROW()-1)+1,7) If you don't want to enter the formula on row 1 then =EOMONTH(A1,ROW(A1)-1)-MOD(EOMONTH(A1,ROW(A1)-1)+1,7) -- Cheers, Shane Devenshire "JudithJubilee" wrote: Hello there, I'm using 2003. I know that you can use the fill series on dates to get every weekday, every 4th of the month, etc. However, I would like to be able to get a list of the dates for the last Friday of each month. Any ideas? Thanks in advance -- Hope this helps |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last working day of month
Note though that the EMONTH function is part of the ATP and some companies
do not install ATP on their employees computers -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi, If you have a list of the a day of each month (any day) in A1:A12, then =EOMONTH(A1,0)-MOD(EOMONTH(A1,0)+1,7) If you just want to enter one day in the first month in cell A1 then use the formula in B1: =EOMONTH(A1,ROW()-1)-MOD(EOMONTH(A1,ROW()-1)+1,7) If you don't want to enter the formula on row 1 then =EOMONTH(A1,ROW(A1)-1)-MOD(EOMONTH(A1,ROW(A1)-1)+1,7) -- Cheers, Shane Devenshire "JudithJubilee" wrote: Hello there, I'm using 2003. I know that you can use the fill series on dates to get every weekday, every 4th of the month, etc. However, I would like to be able to get a list of the dates for the last Friday of each month. Any ideas? Thanks in advance -- Hope this helps |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last working day of month
Hi,
If you enter a date from each month (any day) in A1:A12 then enter this formula in B1:B12: =EOMONTH(A1,0)-MOD(EOMONTH(A1,0)+1,7) Or if you just want to enter one date in Jan in A1 use this formula in B1 and copy it down: =EOMONTH(A1,ROW()-1)-MOD(EOMONTH(A1,ROW()-1)+1,7) If you don't want to enter the formula on row 1 to start: =EOMONTH(A1,ROW(A1)-1)-MOD(EOMONTH(A1,ROW(A1)-1)+1,7) -- Cheers, Shane Devenshire "JudithJubilee" wrote: Hello there, I'm using 2003. I know that you can use the fill series on dates to get every weekday, every 4th of the month, etc. However, I would like to be able to get a list of the dates for the last Friday of each month. Any ideas? Thanks in advance -- Hope this helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working days left in a month. | Excel Worksheet Functions | |||
=month formula no working | Excel Discussion (Misc queries) | |||
amount of working days per month | Excel Discussion (Misc queries) | |||
Last Working Day In Month | New Users to Excel | |||
How to calculate the day before last two working day of each month | Excel Discussion (Misc queries) |