Viewing 5 posts - 1 through 5 (of 5 total)
  • Excel Calender month challenge.
  • dribbling
    Free Member

    Ok.

    User enters a date into a cell that is formatted for dd/mm/yy.

    User received errors when:

    Ther date that is entered, is greater than one calender month from the present day. i.e if the date is today (27/11/12) and a date later than 26/12/12 is entered, it will fail valadation.

    Any thoughts? I’m stumped and quick google didn’t help. (Excel 2002…yes, I know)

    Thanks, Rich

    EDIT: The bit I’m strugling with is the ability for excel to be able to count the approriate number of days, dependent on which months & how many days there are in each. I think simply, does excel have an inbuilt calender?!

    BoardinBob
    Full Member

    Depends on whether you want to count a month as 31 days but

    =if(a1>TODAY()+31,”ERROR”,””)

    Where A1 is the cell the person has entered the date in

    spawnofyorkshire
    Full Member

    i’m using excel 2010 so this might not work

    the formula

    =DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))

    will give you the date one month from today

    so if you want a message to pop up, highlight the cell then under data validation select ‘Date’ and if you have the option of an end date paste the formula above in

    if it needs a start date just put 01/01/1900

    EDIT: The data validation will prevent someone entering the wrong date

    Fresh Goods Friday 696: The Middling Edition

    Fresh Goods Friday 696: The Middlin...
    Latest Singletrack Videos
    dribbling
    Free Member

    Spawnofyorkshire. Ten points and an early finish for you!

    Thanks, worked perfectly 🙂

    spawnofyorkshire
    Full Member

    happy to help

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘Excel Calender month challenge.’ is closed to new replies.