LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Self Population of Date Function

I have formulas in a column that self populate dates in each succeeding cell.
I would like to be able to have the cells stop self populating on the 25th
of each month but have been unable to do so.

In Column B the formula is =IF($M$3=""," ",IF(WEEKDAY(B28)=6,B28+3,B28+1))

I have an associated formula in Column A that self populates with the day of
the week: Monday, Tuesday, Wednesday, etc. The formula in Column A is:

=IF($M$3=""," ",IF(WEEKDAY(B29)=7,B29+3,B29))

Any help you can provide would be most appreciated.


--
SW
 
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
Auto holiday date population Johnny Excel Discussion (Misc queries) 0 April 10th 08 04:08 PM
Average Age of Population on a Specific Date dagostm Excel Worksheet Functions 4 March 21st 07 12:45 PM
Automatic Population Zach Excel Discussion (Misc queries) 4 March 15th 07 01:32 PM
Date Population achapman Excel Worksheet Functions 5 May 11th 06 09:51 PM
Every Sat Date Population Roberta Excel Discussion (Misc queries) 2 January 3rd 06 04:39 PM


All times are GMT +1. The time now is 10:34 AM.

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

About Us

"It's about Microsoft Excel"