+ Reply to Thread
Results 1 to 4 of 4

Find out last week, last month, last quarter from todays date

  1. #1
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Find out last week, last month, last quarter from todays date

    Hey all!
    i have attached the workbook, I have to know through formula which is the last week, last month, last 60 days and so on.
    Thanks!!
    Last edited by meus; 01-16-2015 at 01:27 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Date Functions!!!

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    please describe your problem in the post itself.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Date Functions!!!

    Would this help?
    Attached Files Attached Files

  4. #4
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Date Functions!!!

    I am sorry but that's not the solution i was searching for...
    I have given the column for particular title that should display its particular result.
    Like last week, it should check the supplied date and know if it exists in last week then display that one and so on..
    Thanks anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help Returning The Week Day of a Date Without Using DATE and WEEKDAY Functions
    By vampirealexa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2013, 02:12 AM
  2. [SOLVED] date functions
    By kilomanjaro4 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2013, 09:37 AM
  3. IF and Date Functions
    By Christ4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2006, 11:25 PM
  4. [SOLVED] Date Functions
    By Keith in forum Excel General
    Replies: 2
    Last Post: 04-24-2006, 01:50 PM
  5. [SOLVED] date functions
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 6
    Last Post: 01-05-2006, 12:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1