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 date formating, creating unique calender

I need a formula that will allow me to cycle thru 10 days and back again.

There are 10 levels, starting with level 1.
every day that passes, the level goes up by 1, not to go over 10. So every
10 days, the cycle starts over agan.

So, if something is at a level 4, and 5 days pass, the level is 9. IF its at
a level 4 and 12 days pass, its a level 6.... get it....

HOW DO I DO THIS!!??

I have been working and search for the answer alllll day... please someone
help??
 
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
link a date in excel to calender DFWpcTutor Excel Discussion (Misc queries) 0 March 25th 09 06:57 PM
how do I set up in excel a calender to enter a date Kenneth W. Teribury Excel Discussion (Misc queries) 1 June 16th 06 03:46 PM
How to use Calender control as date chooser in excel?? Rakesh Excel Discussion (Misc queries) 2 May 25th 06 04:33 PM
Adding a date to calender to automatially generate another date? Crystal Long Excel Worksheet Functions 1 January 3rd 06 10:19 PM
How do I copy a date from excel to a outlook calender? Pip Excel Discussion (Misc queries) 0 August 5th 05 01:00 PM


All times are GMT +1. The time now is 01:27 PM.

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"