MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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 ?
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))
=a1+45
that simple.
the date code has units of 1 day.
cheers lads thats got me fixed !
ok moving forward from that how do i make the first cell always read the current day ?
leave cell formatted as date and put this in =NOW()
cheers again , what would I do without STW...
read the manual / help? 😉
tried the help button but its all computor talk to me...lol
=TODAY()
gives you just the date, whereas now gives you the date and time.
Not that important a distinction but cleaner.