 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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?!
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
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
Spawnofyorkshire. Ten points and an early finish for you!
Thanks, worked perfectly 🙂
happy to help