LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mario
 
Posts: n/a
Default Date the input, then tell if over 7th off month


Hello, Can some one tell me how would I have a date appear in column A1
when any number/data is input in column B1 and so on down the column,
and have like A5 tell me if any A1;A2;A3;A4 has a day past the 7th day
of any date? I don't need a year to display if it matters.

Thank You


--
mario
------------------------------------------------------------------------
mario's Profile: http://www.excelforum.com/member.php...o&userid=31116
View this thread: http://www.excelforum.com/showthread...hreadid=508997

 
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
Month to date sales - reset in new month??? [email protected] Excel Worksheet Functions 2 November 26th 05 08:18 PM
extract the month of a date gireesh Excel Discussion (Misc queries) 11 November 23rd 05 06:10 PM
Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. mikeburg Excel Discussion (Misc queries) 5 September 29th 05 06:59 PM
HELP with this function Jay Excel Worksheet Functions 7 May 24th 05 06:45 PM
How do I make a cell date specific to input a value on a specific. ebuzz13 Excel Discussion (Misc queries) 1 January 18th 05 05:53 PM


All times are GMT +1. The time now is 07:01 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"