Forum menu
Topic starter
I need to input the date in one cell and have the adjacent cell show the date 45 days on . How can I do that ?
Posted : 20/03/2009 9:12 am
Format the cells as dates.
Enter the date in the first cell
In the second cell put =+A1+45 (where A1 is the cell with the date - adjust for your cell(s))
Posted : 20/03/2009 9:14 am
=a1+45
that simple.
the date code has units of 1 day.
Posted : 20/03/2009 9:14 am
Topic starter
cheers lads thats got me fixed !
Posted : 20/03/2009 9:17 am
Topic starter
ok moving forward from that how do i make the first cell always read the current day ?
Posted : 20/03/2009 9:19 am
leave cell formatted as date and put this in =NOW()
Posted : 20/03/2009 9:22 am
Topic starter
cheers again , what would I do without STW...
Posted : 20/03/2009 9:25 am
read the manual / help? 😉
Posted : 20/03/2009 9:27 am
Topic starter
tried the help button but its all computor talk to me...lol
Posted : 20/03/2009 10:12 am
=TODAY()
gives you just the date, whereas now gives you the date and time.
Not that important a distinction but cleaner.
Posted : 20/03/2009 10:17 am