Home

Frequency function for counting dates

%3CLINGO-SUB%20id%3D%22lingo-sub-663396%22%20slang%3D%22en-US%22%3EFrequency%20function%20for%20counting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663396%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENew%20to%20this%20board%2C%20new%20to%20Excel%2C%20hours%20of%20reading%20and%20very%20confused%20and%20not%20very%20computer%20literate.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20for%20each%20client%20to%20count%20out%20weeks%20for%20six%20months%20starting%20July%2015%2C%202019%20until%20December%2024%2C%202019.%26nbsp%3B%20It%20could%20be%204%2C%206%20or%208%20weeks%20depending%20on%20the%20client.%26nbsp%3B%20I%20have%20no%20idea%20what%20I%20am%20doing%20wrong%20and%20was%20hoping%20someone%20skilled%20could%20give%20me%20idiot%20directions.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-663396%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-665189%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20function%20for%20counting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-665189%22%20slang%3D%22en-US%22%3EPlease%20cite%20specific%20inputs%20and%20your%20desired%20output%20for%20each%20input.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-668829%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20function%20for%20counting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668829%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20the%20formula's%20I%20am%20getting%20is%20making%20just%20as%20lost%20as%20when%20I%20read%20about%20it%20online.%26nbsp%3B%20I%20need%20something%20much%20more%20dumbed%20down.%26nbsp%3B%20Years%20ago%20someone%20went%20to%20opening%20page%20of%20excel.%26nbsp%3B%20Clicked%20on%20the%20top%20from%20general%20to%20short%20date%2C%20fill%2C%20then%20series%2C%20and%20this%20little%20box%20popped%20up%20but%20I%20do%20not%20remember%20what%20they%20did%20from%20that%20point%20on.%26nbsp%3B%20Whatever%20they%20did%2C%20it%20threw%20out%20all%20the%20dates%20based%20on%20how%20often%20the%20appointment%20was.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20someone%20has%20an%20appointment%20every%206%20weeks%20starting%20July%2015th%20until%20December%2015th%20for%20example%2C%20instead%20of%20me%20counting%20it%20by%20hand%2C%20it%20just%20did%20it%20without%20all%20the%20formula%20stuff.%26nbsp%3B%20Thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-669252%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20function%20for%20counting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-669252%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F353332%22%20target%3D%22_blank%22%3E%40muttmower%3C%2FA%3E%26nbsp%3B%2C%20based%20on%20you%20description%20you%20start%20from%20Home-%26gt%3BFill-Series%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20213px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117183iECDFD10CB2BD64B8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHere%20is%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20297px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117184iD915EE2B4EDE1F54%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E(42%20is%206x7)%20and%20the%20result%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20105px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117185i9AB1D7F5758C333B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EDates%20are%20to%20be%20typed%20in%20your%20locale%20default%20format.%3C%2FP%3E%0A%3CP%3EAlternatively%20you%20may%20use%20in%20Z2%3C%2FP%3E%0A%3CPRE%3E%3DZ1%2B42%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20down%20till%20desired%20date%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-669942%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20function%20for%20counting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-669942%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANK%20YOU!!%26nbsp%3B%20Good%20heavens%20that%20is%20it.%26nbsp%3B%20Simple%20now%20to%20do%20289%20people.%26nbsp%3B%20You%20are%20a%20lifesaver%20Sergei%20for%20making%20this%20idiot%20proof%20for%20those%20of%20us%20who%20have%20no%20idea%20what%20we%20are%20doing%20on%20excel.%26nbsp%3B%20Big%20hugs%20to%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-672749%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20function%20for%20counting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-672749%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F353332%22%20target%3D%22_blank%22%3E%40muttmower%3C%2FA%3E%26nbsp%3B%2C%20Excel%20is%20infinite%2C%20each%20of%20us%20from%20time%20to%20time%20finds%20something%20new%20in%20it.%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E
muttmower
New Contributor

Hello,

 

New to this board, new to Excel, hours of reading and very confused and not very computer literate.  

I need for each client to count out weeks for six months starting July 15, 2019 until December 24, 2019.  It could be 4, 6 or 8 weeks depending on the client.  I have no idea what I am doing wrong and was hoping someone skilled could give me idiot directions.  

 

Thanks for your time.

 

 

5 Replies
Please cite specific inputs and your desired output for each input.
Highlighted

@Twifoo 

 

All the formula's I am getting is making just as lost as when I read about it online.  I need something much more dumbed down.  Years ago someone went to opening page of excel.  Clicked on the top from general to short date, fill, then series, and this little box popped up but I do not remember what they did from that point on.  Whatever they did, it threw out all the dates based on how often the appointment was.

 

If someone has an appointment every 6 weeks starting July 15th until December 15th for example, instead of me counting it by hand, it just did it without all the formula stuff.  Thanks

 

@muttmower , based on you description you start from Home->Fill-Series

image.png

Here is like

image.png

(42 is 6x7) and the result is

image.png

Dates are to be typed in your locale default format.

Alternatively you may use in Z2

=Z1+42

and drag it down till desired date

@Sergei Baklan 

 

THANK YOU!!  Good heavens that is it.  Simple now to do 289 people.  You are a lifesaver Sergei for making this idiot proof for those of us who have no idea what we are doing on excel.  Big hugs to you!

@muttmower , Excel is infinite, each of us from time to time finds something new in it.

You are welcome.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies