#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kay Kay is offline
external usenet poster
 
Posts: 129
Default calculating days

I have a cell with the start date included month, day and year; I have other
columns from january to december. I need to allot 3 day evenly per year that
is day 1 day every 4 month starting with the month in the cell I already have
(start date). Any suggestion?
--
KK
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default calculating days

See your post a few hours ago in another group. Please don't multipost.
--
David Biddulph

"Kay" wrote in message
...
I have a cell with the start date included month, day and year; I have
other
columns from january to december. I need to allot 3 day evenly per year
that
is day 1 day every 4 month starting with the month in the cell I already
have
(start date). Any suggestion?
--
KK



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kay Kay is offline
external usenet poster
 
Posts: 129
Default calculating days

I am sorry I place it in the wrong section before; I still didn't get the
correct formula. I need to actually enter the number 1 in the cell.
--
KK


"David Biddulph" wrote:

See your post a few hours ago in another group. Please don't multipost.
--
David Biddulph

"Kay" wrote in message
...
I have a cell with the start date included month, day and year; I have
other
columns from january to december. I need to allot 3 day evenly per year
that
is day 1 day every 4 month starting with the month in the cell I already
have
(start date). Any suggestion?
--
KK




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
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux[_2_] Excel Worksheet Functions 2 October 11th 07 02:04 PM
calculating # of days leslie Excel Worksheet Functions 2 June 24th 07 01:21 AM
Days per month for calculating storage days Bart Excel Worksheet Functions 3 January 31st 07 06:40 PM
calculating days Jason - MR Excel Discussion (Misc queries) 3 January 26th 06 07:23 PM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM


All times are GMT +1. The time now is 04:41 PM.

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

About Us

"It's about Microsoft Excel"